you can import the database

articlemaster — Sun, 31 May 2009 19:52:00 +0000

you can import the database easier via ssh if you have it:

mysql -u username -pyourpassword db_name < yourdb_youareinstalling.sql
Reply With Quote

#The -pyourpassword is correct! Normally you do -p, but you can do -pyourpassword to pass the password on so you don't have to type it in.

You export the

ericstan — Sun, 22 Feb 2009 17:07:01 +0000

You export the database.
Upload it to your host and import it at PHPMyAdmin.
Simple as that!

You can use phpMyAdmin,

AndrewCF — Sat, 24 Jan 2009 13:40:33 +0000

You can use phpMyAdmin, export from your localhost, and then import to your server.

Also, you can try Mysql command - mysqldump. Launch following command on your local machine:

mysqldump -h localhost -u root -pPASSWORD LOCAL_DATABASE_NAME -c | mysql -h REMOTE_HOST_IP -u root -pPASSWORD REMOTE_DATABASE_NAME

Please make sure you can connect to remote mysql server in your local machine.

It depends on what is in

webwiz — Sat, 22 Nov 2008 05:13:01 +0000

It depends on what is in your database. Any configuration data referring to your localhost setup is likely to fail, but application data will likely survive. Just fire up phpMyAdmin, select the database, and use the export tab. Export as SQL - only use compression if the tables are huge - and FTP the result to your host, putting the file somewhere off the document root where you can find it again.

On your new host, fire up phpMyAdmin from your cpanel, create an empty database, then use the import tab and look for your uploaded SQL file by pressing the 'Choose file' button.

Note that you can easily erase the tables and repeat the process if something goes wrong. And you can take a look at the table entries after importing to check things before trying to access them from a program.

You will likely have to change the database password and a few other details in your programs, but hopefully you have an INCLUDE file with configuration data like this in it, so you can change it in one place.

There's a lot more help on Apache and PHP forums with more detail than I can give here. But I hope I encouraged you, anyway.