Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Restoring Backup SQL Errors


Shyone44

Recommended Posts

:blink: I have a backup of my site on my hard drive. I have been trying for days to get it restored on my new host. The site was down for a few months. I am trying to upload to MySQL but I keep getting an 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 './' at line 1 "

I am really trying to make my way through this, but it isn't easy. Any help will be So APPRECIATED!!!

Thank You! :thumbsup:

Link to comment
Share on other sites

:blink: I have a backup of my site on my hard drive. I have been trying for days to get it restored on my new host. The site was down for a few months. I am trying to upload to MySQL but I keep getting an 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 './' at line 1 "

I am really trying to make my way through this, but it isn't easy. Any help will be So APPRECIATED!!!

Thank You! :thumbsup:

 

Hi,

 

Some questions to understand your problem:

Is it a "sql instructions" backup (a text file with CREATE TABLE and INSERT commands)?

What are you using to upload the backup? phpMyAdmin?

What version of MySQL are you using?

Could you at least create any table? or none at all?

Is the database already created?

 

If you have a SQL text file, and phpMyAdmin you may try copying and pasting the first CREATE TABLE to the SQL window of phpMyAdmin and see the results in detail. If it doesn't work you may paste that instruction here and some one may assist you.

 

regards,

Freddy

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...