Posted on: 12/10/02 05:53pm
By: 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
Restoring a backup!
Posted on: 12/11/02 01:30am
By: Dirk
Try it from the command line:
mysql -uusername -ppassword -Ddatabase_name < your_backup.sql
bye, Dirk
Restoring a backup!
Posted on: 01/28/03 02:16am
By: Anonymous (eccc)
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!
Restoring a backup!
Posted on: 02/01/03 02:49am
By: twohawks
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.
Re:Restoring a backup!
Posted on: 09/12/03 07:38pm
By: Blaine
Try using your editor and replacing all -- with // to indicate a comment.
Re:Restoring a backup!
Posted on: 09/13/03 12:24pm
By: DTrumbower
[QUOTE BY= eccc] . The \"---\" throws phpMyAdmin off every time![/QUOTE]
That would be a problem with phpMyAdmin. The backup is down with mysqldump, no intervetion from geeklog code.