#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
Do you have shell access to both of your hosts? It would be very easy if you did. Otherwise, you can manually download the database backup file from your existing host to your desktop then upload via FTP to your new host. Then you can restore the database via SSH on your new host, or upload the file to your /var/database/backup/ folder and restore it through CS-Cart.
Do you have shell access to both of your hosts? It would be very easy if you did. Otherwise, you can manually download the database backup file from your existing host to your desktop then upload via FTP to your new host. Then you can restore the database via SSH on your new host, or upload the file to your /var/database/backup/ folder and restore it through CS-Cart.
[/quote]
I know I dont on the old host, not sure about the new host.
I do have a FTP client. I use filezilla. Im uploading all the Filemanager files now from the old filemanager to the new filemanger. (All the installtion files and images, ect)
Sorry if Im asking alot of questions but how would I restore it through CS-cart?
Im assuming I would install a fresh install on the cPanel. Go into the admin panel and then go to admin/ then databse and click restore DB.
But If I do that, I would lose all my pages, block settings, and my layout ive changed wouldn't I?
I know I dont on the old host, not sure about the new host.
I do have a FTP client. I use filezilla. Im uploading all the Filemanager files now from the old filemanager to the new filemanger. (All the installtion files and images, ect)
Sorry if Im asking alot of questions but how would I restore it through CS-cart?
Im assuming I would install a fresh install on the cPanel. Go into the admin panel and then go to admin/ then databse and click restore DB.
But If I do that, I would lose all my pages, block settings, and my layout ive changed wouldn't I?
[/quote]
I would install a fresh copy of the same version on the new server.
Download a full backup of all files from your existing server.
Upload your skin (and any custom addons if you have any) folder to the new installation
Complete the new install, and select your skin on the new install. Now all you should be missing, is your blocks layouts, products, customers, orders, settings, etc.
Now go to your existing live site, complete a full database backup and download that file.
Restore that database file to your new server, ensuring the database name and access details are set in config.local.php
The database stores the infomation for your pages, block settings, layout, etc, so you will be restoring them when you restore your database backup.
Close the existing storefront, ensure you have all the customers/orders migrated, update the domain DNS records, wait for your site to go live on the new site once DNS has resolved.
The database won't, as far as I understand, upgrade from 3.0.3 to 3.0.5 if you restore a database from a previous version (ie. restore 3.0.3 database using 3.0.5). I haven't compared the database structures between 3.0.3, 3.0.4 or 3.0.5 to see if there are any differences in table names or field names. You will need to install 3.0.3 and then upgrade to 3.0.5.
In this case, it would be a safer option to upgrade your current site to 3.0.5 and then transfer it to the new server.
Well mostly everything seems to have worked except a few issues.
I did what you said by putting the DB backup in the var folder and restoring it through CS-Cart.
For some reason though it didn't copy all my products over. Shows only about 18,000 vs my 32,000 I have.
I even tried to export the_products table out by itself and import it in and wont accept anymore of it.
Not sure why it wont take the full DB.
And when I try to do anything on the home page, I get this error:
Fatal error: Call to undefined function smarty_modifier_fn_seo_is_indexed_page() in /home/harpermo/public_html/var/cache/templates/customer/%%45^45E^45E480CD%%index.tpl.php on line 59
You need to make sure all your skins folder is intact and has the correct permissions, same goes for the /var/ directory and subfolders. Clearing the cache normally resolves that error.
As for the database…I'm at a loss with that one. Does phpMyAdmin report any errors? How many rows are in your existing products table in comparison to the new products table?
You need to make sure all your skins folder is intact and has the correct permissions, same goes for the /var/ directory and subfolders. Clearing the cache normally resolves that error.
As for the database…I'm at a loss with that one. Does phpMyAdmin report any errors? How many rows are in your existing products table in comparison to the new products table?
[/quote]
The phpMyAdmin didn't report an error.
When I restored the DB through the admin panel of the website, it said it had finish successfully. No error.
The DB didnt report an error either when I tried to upload the harpermo_products table in by itsself either.
The error that is displayed above only displayed when I tried to refresh the customer home page.
The current DB on the live site has 693,518 rows/ 144.3 Mb
Unless you're using the files from your existing server, it might be easier to use the files from your existing site. When certain addons are installed, their files are copied into your skin folder, so using a clean install of 3.0.3 to import a 3.0.3 database which thinks the addons are already installed may cause you problems.
Follow the guide for moving to a new host - although you might have a little more fun with that database. In the existing store, in Administration>Database, run the Maintenance task which might repair any wrongdoings in the database.
You will only be able to install the certificate once your domains DNS points to the new host. You will need to generate a new certificate signing request (CSR) on the new host to supply to your SSL certificate providers to re-issue a new SSL certificate for that server.