« home

MySQL Dump Export/Import And Table Name Case Sensitivity

posted on

Before Blojsom 3, I could get away with moving my blog content from my web host to my home environment (and vice versa) simply by moving the text files. Now that I’m using MySQL for Blojsom 3, I figured that the easiest way is to use MySQL dump. Export to the dump file: mysqldump -p -u [username] [dbname] > [dumpfile].sql Import from the dump file: mysql -p -u [username] [dbname] < [dumpfile].sql This might not be a good solution if you have a large amount of records, but that will do for me for now.…

more »