Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 08:25 am EDT

Geeklog Forums

Restoring a backup!


Anonymous

Anonymous
I wish to restore a backup created by the geeklog admin. I dropped all of my geeklog tables then loaded the output file created by the backup, but all I get is the following error message: Error SQL-query : * - * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - * - * - CREATE TABLE banned_ips( host_ip varchar( 255 ) default NULL ) TYPE = MyISAM MySQL said: You have an error in your SQL syntax near '--------------------------------------------------------- -- -- CREATE TABL' at line 2
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany

Try it from the command line:

mysql -uusername -ppassword -Ddatabase_name < your_backup.sql

bye, Dirk

 Quote

eccc

Anonymous
So what do you do if you don't have command line access? That's the boat I'm in. I think the DB Backup needs to be REDONE so that it works from the command line AND through phpMyAdmin. The "---" throws phpMyAdmin off every time!
 Quote

Status: offline

twohawks

Forum User
Junior
Registered: 12/17/01
Posts: 33
Open your sql file in an text editor and remove the "---" by hand. It's the only way I was able to do it too. It's tedious but it works.
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
Try using your editor and replacing all -- with // to indicate a comment.
Geeklog components by PortalParts -- www.portalparts.com
 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
Quote by eccc: . The \"---\" throws phpMyAdmin off every time!
That would be a problem with phpMyAdmin. The backup is down with mysqldump, no intervetion from geeklog code.
 Quote

All times are EDT. The time is now 08:25 am.

  • 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