Transferring Databases

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
punkandjunk
Forum Newbie
Posts: 8
Joined: Thu Jul 17, 2003 12:07 am
Location: Jackson MI

Transferring Databases

Post 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?
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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
punkandjunk
Forum Newbie
Posts: 8
Joined: Thu Jul 17, 2003 12:07 am
Location: Jackson MI

Post by punkandjunk »

thank you very much, works like a charm
Post Reply