How do I transfer a database from my old host to my new one? I have access to both FTP sites, but I don't know where a database is stored or what the file extension(s) is/are.
Transferring a database between servers
Miscellaneous Forums/General Discussion/Transferring a database between servers Are you using phpMyAdmin? If you are, there is an option somewhere in the settings options tab to export your database to a file, and then you can import it again on the other server.
If it's for a forum, there should be 'Backup database / Restore database' options in the control/admin panel. Just backup to your local drive and do a restore on the new server. It's the simplest way of doing it, I think.
with most SQL engines (MYSQL, TFT, RDB) there is usually a command to export as po states. This exports in the form of a SQL script. When it is run from your new database, it basically does the adds, inserts, etc for you (as is defined in the exported script).
The script usually looks like a bunch of sql commands (which is what it is).
The script usually looks like a bunch of sql commands (which is what it is).
You need to use a FTP program. Login to your site and look for the mysql (or whatever the geeks on your network named the folder) and D/L it. I really doubt you could do it through a control panel / front end. Those are designed foor the MAC users in the Universe... keeps them from burning themselves whilst playing with matches...
Use the tools from MySQL to back up and restore. If the
server doesn't have the port open for remote connections
then you need to connect to the server via terminal telnet
or putty and run a few simple commands to backup the data
and transfer it to the new server for restore.
server doesn't have the port open for remote connections
then you need to connect to the server via terminal telnet
or putty and run a few simple commands to backup the data
and transfer it to the new server for restore.
phpMyAdmin to dump, then restore to new server, it's done.