₦airaland Forum

how can one upload a mysql database to server. I installes xamp to my system that is not connected to net, now my problem is how to upload the mysql database to my remote server.

Brother, you don't have a problem,  Okay just call it a challenge,  don't say a problem. okay back to your challenge,  what you need to do is,  open your phpmyadmin on your remote server, and open your phpmyadmin on your local server too,  now go to EXPORT on your local server,  thereafter save it anywhere on your PC, then go back to your Remote Server, on your phpmyadmin, click on Import and browse where u export your sql data too and import it. thats it simple as that !

And make some corrections on your DB connection, on your remote server unlike you will have

$server = 'localhost'
$username = 'root'
$password = ''
$database ='kelechido'

This works like this on Xampps
========================
it will now be
========================
$server = 'localhost'
$username = 'usernme_db'
$password = 'Password_db'
$database ='kelechido'

This works on Cpanel

Mysql database must be installed on your remote server to begin with.