Moving Database from One Server to Another

If you are moving Sytist or Photo Cart to a new server or hosting company, you also have to move the database which isn't located where all the files and folder are.

To move your database from one host to another, it will need to be exported from the old host and imported into the new one.

Log into your hosting control panel of the host you are moving from and go to the PHPMyAdmin section. If you are using cPanel hosting, you will find it in the screen shot below:

When you are in PHPMyAdmin select your database which will be on the left of the screen, then click the Export tab at the top of the page.

The next screen just leave it on Quick and click Go. You will be prompt to save or open a sql a file. Save the file to your computer.

No log into your new hosting control panel and create a new database. If it is cPanel hosting, see this page on how to create a new MySQL database.

After you have created a new database, go to the PHPMyAdmin section and click the Import tab.

The next screen, click the Browse button to select the sql file you saved to your computer then click go at the bottom.

Once that is done, your database has been imported. The final thing you need to do is edit the configuration files.

In Sytist the configuration file is sy-config.php in the main website folder.

In Photo Cart the configuration file is setup.php in your Photo Cart folder.

Download that file and open it in a text editor like notepad ... do NOT use Word.

You will need to change the database name, username and password as highlighted below. Save and re-upload to your new website.

 
 
Sign up for email promotions.
Your information is safe with us and won't be shared.
Thank you for signing up!
 
©2003 - 2017 Grissett, LLC. All Rights Reserved.
Loading More Photos
Scroll To Top
Close Window
Loading
Close