Importing SQL dumps into MySQL through Command line
A quick way to duplicate MySQL databases is to do the following:
Step 1: Dump the database either through PHPMyAdmin’s export form or through mysqldump (as I mentioned above). Note (usually, it’s mysqldump -h -u -p if you ommit the -h switch it will default to “localhost”). After you enter the command below and press enter, you will be prompted for a password because you did not enter the password after the -p switch.
Step 2: Once you have the sql file, log into mysql and create a database or “use” an existing database - again, ommiting the -h will default to localhost and you will be prompted for a password if you don’t enter a password after the -p switch.
Step 3: After logging in, you will need to either create a new database and select the database for use with the import, or use an existing database. For this example, we’ll create a new database. Remember to use backticks and not apostrophe’s to create your new MySQL database.
Step 4: Alright! Now we’re ready to start using! Issue a “use” statement to select the empty database
Step 5: Remember where you put the SQL file and issue a “source” command:
The query is executed and if you didn’t mess around with the SQL produced by mysqldump, it should run things flawless
Do not bother with BigDump. When mysql can do it for you quicker!
