Welcome to Geeklog, Anonymous Tuesday, January 07 2025 @ 09:58 pm EST

Geeklog Forums

Can't use MySQL backups...


Anonymous

Anonymous
I am moving to a new host and backed up my DB with Geeklog, however when I try to insert the SQL file into the new DB, I get this: You have an error in your SQL syntax near '--------------------------------------------------------- -- -- CREATE TABLE gl' at line 2 I know it's simple but need some help fixing it please. Thanks. John
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
How are you trying to restore the backup? mysql -uusername -p -D database < backup.sql works for me ... bye, Dirk
 Quote

All times are EST. The time is now 09:58 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content