Importing data into one of your MySQL tables is really easy using the Load Data command. In this exercise we will look at importing a comma separated list of countries into our Country table. Below is the script you would run in your MySQL Query Browser (or phpMyAdmin tool): Now we’ll break down a couple [...]
Tag: MySQL
Script MySQL Schema and Data with mysqldump
Last night I needed to generate a script of a local MySQL database, dump the data, then load it on a remote server. I didn’t have my handy dandy SQL Server Integration Services toolset, but did find a pretty cool utility: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html. Running this program will generate a DROP/CREATE script for your database, and if [...]




