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:
˅˅˅ Additional valuable information is available at one of the links below: ˅˅˅
Did you like the article? Let Google Search know by clicking this button:
Page last modified 31-Dec-12 22:06:21 EST