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: ˅˅˅

 

Did you like the article? Let Google Search know by clicking this button: . Please link to content that you find useful on this website on your own website, forum or blog! You can also comment on this page below, or contact me to ask a question or suggest a topic for me to research. There is a user-editable Wiki available on my website, as well as a Forum that you can contribute to. Site Map.

Page last modified 31-Dec-12 22:06:21 EST
Comments on this page:


Add a comment to this page
Comment Title:
Your Name:
Your Email Address:
Notify me of new comments to this item:
Additional Comments:
This is a captcha-picture. It is used to prevent mass-access by robots. (see: www.captcha.net)