I created an application locally on my pc using xampp and phpmyadmin, now i want to put the application on my website, but i dont know how to move it from my pc to the web, especially the database and the tables...help urgently needed.

5 Years
Discussion Span
Last Post by diafol

What you can do is go to 'Export' on your PHPMyAdmin (local version) and save the SQL file.

When you go to your remote version of PHPMyAdmin you need to go to 'Import' and it shall bring in all the databases, tables and data included.

Good luck!


That will only work with relatively small databases (phpMyAdmin is a PHP-based app, and limited by PHP memory limits before it will simply timeout). You might need to use a terminal-based command such as mysqldump.


Thanks for your responses, really appreciate it, d database is relatively small, and i've exported the database as a sql file, but i dont know how to integrate it in my website using filezilla, any idea?


You don't need filezilla to import the DB. Just open phpmyadmin on your site and import the file.


Filezilla will upload your site files though.

Remember to change your DB connection details in your php file(s) if they're different

Edited by diafol

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.