I created a database of six tables for an intranet. Now I would like to export this database to the server. How to do?? Do I just have to copy the MYI, MYD and FRM files on the server???
Thank you very much
Export a database
Moderator: General Moderators
It's simple.
You have to use a programm called mysqldump.
Så on your development machine you'll write
mysqldump databasename > scriptfile.sql
And on your intranetserver you write.
mysqladmin create databasename
cat scriptfile.sql | mysql databasename
I assume you use Unix. But I assume thate the mysqldump program is included in the windows dist as well.
Read the manual for mysqldump, it can bu configured not to include data and just the schema and so on.
Good Luck!
You have to use a programm called mysqldump.
Så on your development machine you'll write
mysqldump databasename > scriptfile.sql
And on your intranetserver you write.
mysqladmin create databasename
cat scriptfile.sql | mysql databasename
I assume you use Unix. But I assume thate the mysqldump program is included in the windows dist as well.
Read the manual for mysqldump, it can bu configured not to include data and just the schema and so on.
Good Luck!