MKRD.info - Thorough articles on a variety of topics, and no ads!

Importing the dump file into a MySQL database

We are now ready to import our modified file into a new database. Follow this procedure:

1) Create a new MySQL version 5 database. Save the database password you have specified.

You will need to wait some time after you initiate database creation until the database becomes available to you.

If you are given an option, specify UTF8 for charset, and UTF8_General_ci for collation.

2) When the database becomes available to you, login into the database thru PHP MyAdmin, go to the Operations tab, and check what the Collation is set to. If it again defaulted to something other than UTF8_general_ci or UTF_Unicode_ci, then select the proper collation, and press GO.

3) We are ready to import the database. On SSH, specify the following:

mysql -h dbhost -u dbusername --password=dbpassword --default-character-set=utf8 dbname < creativeanddatedfilename.sql

You may see one of several errors while trying to do this:

What will not work

Can't connect to local MySQL server through socket

Can't connect to local MySQL server through socket

MySQL Error Specified key was too long

˅˅˅ Additional valuable information is available at one of the links below: ˅˅˅