CDROM-Guide forums  

PDA

View Full Version : Moving a Forum database


   
Turbodiesel1973
Apr 23, 2003, 07:13 AM
Right here is the problem. I have a small forum which is slowly growing to be larger then I'd ever expected. The host I use only has a 5mb mySQL database which is almost full. I need to move to another paid host with a larger database.

Is it possible to move the database containing the existing posts and members over to the new site?. If so how do I go about doing it?.

Oh and it's an invision V1.1 Forum!.

t.i.a

Chris

Captain
Apr 23, 2003, 01:17 PM
You need to create a dump of the database using mysql or another application. If you have access to mysql at the command line then you can use mysqldump. This creates a text file containing all the data and optionally the database structure.

Alternatively you could use a web-based tool like phpMyAdmin to dump and restore the database.