migrating from xampp to a remote host
Posted: 26. December 2012 20:31
I have developed a database using XAMPP. Please would you explain how I migrate the database and its php pages to a remote commercial host.
The steps I think I already understand are:
1. Use phpMyAdmin to export an SQL file of my database and tables.
2. Use my FTP client to transfer the SQL file and all the php and html files from htdocs to the public_html folder in the host.
3. Use the host's control panel to access phpMyAdmin and then import the SQL file containing my database and tables.
Its the next bit that I find diffcult to understand:
Databases created directly on the host using phpMyAdmin are prefixed with my control panel username. How do I cope with this as my XAMPP database is not prefixed with my CP username.
My mysqli_connect.php file contains the details relevant to the database created with XAMPP. Which of those details have to be changed in order to access the database on the host. Can I assume that the user, password and localhost can remain unchanged?
The steps I think I already understand are:
1. Use phpMyAdmin to export an SQL file of my database and tables.
2. Use my FTP client to transfer the SQL file and all the php and html files from htdocs to the public_html folder in the host.
3. Use the host's control panel to access phpMyAdmin and then import the SQL file containing my database and tables.
Its the next bit that I find diffcult to understand:
Databases created directly on the host using phpMyAdmin are prefixed with my control panel username. How do I cope with this as my XAMPP database is not prefixed with my CP username.
My mysqli_connect.php file contains the details relevant to the database created with XAMPP. Which of those details have to be changed in order to access the database on the host. Can I assume that the user, password and localhost can remain unchanged?