I’m using Yank’s book, “PHP & MYSQL Novice to Ninja” and have just created my first database driven website on my development server. However, the book gives me zero clues as to which database files I now need to move to my online web host environment. I can create a new db there, but I don’t want to have to retype all my data. How is this done?
dump your database… this creates a “.sql” file consisting of CREATE and INSERT statements
upload the .sql file to your host, and run it into your database there
Thanks. That would be “mysqldump” run from the command line?
yeah, it could be
but you might want to give heidisql a try
it has an option to dump a database which runs mysqldump “under the covers” but has a much nicer user interface than the command line
and then of course, just switch over to the production server and run the same file back in