The question on uploading databases to hosting!

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.

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.

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

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.