Page 1 of 1
Transferring Databases
Posted: Thu Sep 11, 2003 8:14 am
by punkandjunk
I just got a new host and I wanna transfer my databases, or at least the tables into the new DB. Both hosts use phpmyadmin. I wanna make sure the tables are all there and set up before I transfer the domain name there and the site not work.
any tutorials on that?
Posted: Thu Sep 11, 2003 10:48 am
by JAM
I'm not sure there are any of those (anyone might want to write one?), but it's really very simple, at least if you have the opportunity of using same tools as I.
Either phpMyAdmin
1. Select your database in the left frame.
2. In the right frame, click 'Export'.
3. Choose (using an example) your tables, and 'SQL', 'Structure', 'Data' and 'Save as file'.
4. Press Go.
5. Connect to your other source.
6. Press 'SQL' in the right frame.
7. Choose the location of your previously saved file (or paste the contents of it). Remeber to choose the correct compression if any.
8. Press GO. Voilá.
Other options is using the MySQL-Front software (Win32, GUI based). In this software there are a Im/Export menu, that easely will guide you in the process (supports server to server exporting).
Good luck, hope it helped.
Mysql-Front
phpMyAdmin
Posted: Thu Sep 11, 2003 4:53 pm
by punkandjunk
thank you very much, works like a charm