MySql

[lapo4ka18]

Hello,
i am planning to move my web site to this hosting company,
and all my information is in mysql database on their servers.
If i'll move to another hosting company, it means that i will lose all my clients info, and I have to retype their information again to the new mysql database, or there is a way to download everything from their mysql database to this one.


SexyOrNasty.com (http://sexyornasty.com)

[pieterhielema]

I think you can simply dump the data from the old database and load it into the new one.

You can use PHPMyAdmin of MySQLFront (and probably more).

Friendly greetings,

Pieter
http://www.pbholland.com

[lapo4ka18]

I am new to that, so I really didn't understand what that means. Can you give me step by step instructions, other wise I am not going to be able to do that?

I really appreciate it.

Thanks

[pieterhielema]

1. MySQLFront
Export/ Dump
If you use MySQlFront there is a option in the menu saying im/export. Click that and choose export tables.
Continue confirming the next choices and the program will make a file with your complete datastructure and data.

Import
Go to the new database and choose import and take the file you created. Is should load the whole database

2. PHPMyAdmin
Export/ Dump
Click on the name of your database (left menu). In the right frame you will see all your tables. A little bit lower there is an option to dump the database. Choose structure and data and send this to a file (read through the available options).

Import
Go to the new database. Click on the name of your database (left menu). In the right frame you will see all your tables. A little bit lower there is an option to type the filename with the query you want to be executed. Of course here you choose the newly made file.

It should be no problem, but please first finish the process before you drop the old database ;)

P.S.
MySQLFront you can get here http://anse.de/mysqlfront/

PHPMyAdmin is available here http://phpwizard.net/projects/phpMyAdmin/
with a instruction how to get it working http://www.powhelp.com/viewtopic.php?t=42

Friendly greetings and succes,

Pieter