I am moving my Beehive webforum, which uses a mysql database, to a new server. When I try to export the database, it creates a file OK. But when I try to import it, it does not import, and gives an error message.

I'm new to both sql and php. I just want to do this task so I can move to the new server.

How do I move data from an sql database from one server to another?

The two databases were both created by the Beehive web forum install script, and I believe they are identical. They show the same number of tables, etc. Its a PHP forum, and install script.

I use phpadmin to export and import the database file. What should the settings be?

Thanks! I'm really frustrated at this point.

Wayne from White Salmon

Hello Wayne,

It has been a while since I used phpmyadmin to backup a MySQL database and the last time I did it, phpmyadmin did a lousy job. http://www.desilva.biz/mysql/mysqlbak.html.

You need to have shell access to the servers (old and new) so you can use mysqldump instead. Also, the version of the MySQL server is important e.g. 4.0 vs 4.1, as quite a few things have changed.

If you do not have shell access, you need to ask your web host (old) to backup the databases and send them to you. Then you can send the file to the new host and ask them to use it to restore the database on the new server. It's a courtesy most hosts will extend to you.

__________________
J de Silva
Learning Journal | GIDForums™ | GIDNetwork™ | GIDWebhosts™ | GIDSearch™

One helpful too i've always used when dealing with MySQL is "Navicat" awsome program for database management. However its not required to export your database, it makes it a lot easier. Another program is MySQL Front. Both of them come with a free trial, however the software for Navicat is a pretty penny. If your doing a lot of work with DB's though i'd advise getting some 3rd party software to help manage it.

But like Jds said you need some kind of shell access to be able to connect to the db and export.

__________________
There are 10 kinds of people in this world. Those who speak binary and those who dont.