[SOLVE] Database Backup and Restore

[guyen]

Hello, I am currently trying to migrate my prestashop store to another server. I've copied all the files from the ftp over to the new server, however when trying to export the db, I was able to download both the uncompressed and compressed versions. I only encounter an error when importing the backups; regardless whether it was uncompressed or compressed. the error I would get is,

Error
MySQL said:

#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 ''2010-12-13 09' at line 90

or

#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 '

Fatal error: Allowed memory size of 94371840 bytes exhausted (tri' at line 1

I've followed the phpMyAdmin tutorials in the wiki, it's not helping me.

[David520]

wordpress there is a permanent link to a URL set of course use this link to support your server needs rewrite functions (that is, we often say that the pseudo-static opening), use this link to confirm use of a permanent link to the article title, then you can set up their own page name is the. So how to set a permanent link to it? Login WordPress control panel find the Options menu, select the permanent link and choose the structure of a permanent link, or your own custom one, it is best to set a static page, to facilitate the search engines. Usually set a fixed link is: /% category% /% postname%. Html this type. I also use the php program to build a few wordpress blog site, modern-sunglasses.com, new-designer-sunglasses.org, new-designer-sunglasses.net, I was so optimized, this is my point contribution.

[guyen]

wordpress there is a permanent link to a URL set of course use this link to support your server needs rewrite functions (that is, we often say that the pseudo-static opening), use this link to confirm use of a permanent link to the article title, then you can set up their own page name is the. So how to set a permanent link to it? Login WordPress control panel find the Options menu, select the permanent link and choose the structure of a permanent link, or your own custom one, it is best to set a static page, to facilitate the search engines. Usually set a fixed link is: /% category% /% postname%. Html this type. I also use the php program to build a few wordpress blog site, modern-sunglasses.com, new-designer-sunglasses.org, new-designer-sunglasses.net, I was so optimized, this is my point contribution.

This has nothing to do with helping me. Also, it makes no sense.

[mytheory.]

I'm by no means an expert in mysql... but I have backed up and restored several servers using mysql. I've also changed servers a couple of times for our shop using PS, and have experience in both windows and linux environments.

With that said... maybe I can help in some way or another. But first, I'm guessing you are moving to a shared host, yes?

Also, how are you backing up your database? creating a dump? Also, how are you trying to restore your database? via command line or phpmyadmin or workbench?

From my experience, the easiest way to export and import a database was to create a dump file with the .sql extension. I forget the the exact command to do this via the command line method, but there is ample info out there. If you are using phpmyadmin you can easy create a backup of your database and just make sure to select the option to back up as a sql file. Using similar process, you can simply import the sql file via phpmyadmin. This has worked every time except once... when I switched from my personal server to a shared host (for another client) their database naming convention was different... where on my own server I had the option of creating any database name, ie. prestashopdb, but the shared host (like most) let you create your own database names but they would always attach a prefix to it, ie. username_prestashopdb. Which changes the environment... I remember I had to modify a line of the sql dump/backup file to change it from looking for my "old" database name to the new one created on the host. I'm not sure what error I got but it could have been similar.

HTH!

[gonebdg - webindoshop.com]

Hello, I am currently trying to migrate my prestashop store to another server. I've copied all the files from the ftp over to the new server, however when trying to export the db, I was able to download both the uncompressed and compressed versions. I only encounter an error when importing the backups; regardless whether it was uncompressed or compressed. the error I would get is,

Error
MySQL said:

#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 ''2010-12-13 09' at line 90

or

#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 '

Fatal error: Allowed memory size of 94371840 bytes exhausted (tri' at line 1

I've followed the phpMyAdmin tutorials in the wiki, it's not helping me.

Allowed memory size of 94371840 bytes exhausted


mean .. Your sql size is more bigger than that

You have to split your database when you made database backup

You can do that from phpMyAdmin >> Tab Export >> Select table to export (backup)

[iulian80]

My error on phpmyadmin its:

CREATE TABLE `ps_access` (  `id_profile` int(10) unsigned NOT NULL,  `id_tab` int(10) unsigned NOT NULL,  `view` int(11) NOT NULL,  `add` int(11) NOT NULL,  `edit` int(11) NOT NULL,  `delete` int(11) NOT NULL,  PRIMARY KEY (`id_profile`,`id_tab`)) TYPE=InnoDB;

MySQL zice:

#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 'TYPE=InnoDB' at line 9