I have developed a web application in VS 2005, and it uses MySql 4.1 as database.
Now, I have created the database and tables, and there is data in it.
How can I copy this same database along with its tables and contents, to another server?
Which all files should I copy?
Is there any procedure to 'attach' a database?
I use MySql Manager to create databases and tables.
The best way to make a dump of your existsing MySql database is to use mysqldump utility which comes with any mysql server package.
Here is a sample usage: "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqldump.exe" --host=servername --user=dbusername --password=dbpass databasename > "c:\databasebackup.sql" - this will create a database backup for you on your C:\ drive named databasebackup.sql
In order to restore the newly created backup use the following utility: "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe --host=servername --user=dbusername --password=dbpass databasename < "c:\databasebackup.sql"
That works great for me.
Try to use MySQL Administrator tool.
Take backup and execute on remote server.