Geeklog Forums

Unfortunately GLs backup utility doesn't work for me but I am using phpMyAdmin 2.4.0... I just tried a backup using it and these were my selections... 1. Select All 2. Structure and Data 3. Save as File (ZIP) 4. Go! I did not select either of the options below... Add 'drop table' Complete inserts Extended inserts Enclose table and field names with backquotes I then dropped the database and installed the backup, everything looks fine and I haven't yet run into any problems... The reason why I am asking though is because I remember once running the backup through phpMyAdmin but I ran into problems... Did I do it right this time or am I sitting on a time bomb? Thanks

---

Victor B. Gonzalez -
http://aeonserv.com

I've never used phpMyAdmin to do backups (since I use either Geeklog's backup function or Tony's backup script), but you may need to use the "Enclose table and field names with backquotes" when you've installed some plugins (specifically the Geekary, I think) which use non-standard characters in their table names. But since you were able to import your backup, it looks like you didn't have this problem.

bye, Dirk

Actually, this is a topic I have been meaning to bring up...

I am able to successfully backup my GL db by way of the DB Backups feature, but I am having difficulty restoring to a test db (wanting to ensure the backup / restore process I am using is working).

I am using phpMyAdmin 2.4.0 and MySQL 4.0.12, and am getting the following errors:

--

Notice: Undefined variable: db in /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php on line 215

Warning: Cannot add header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php:215) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/main.php on line 25

Warning: Cannot add header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php:215) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ob.lib.php on line 65

Warning: Cannot add header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php:215) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/header.inc.php on line 27

Warning: Cannot add header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php:215) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/header.inc.php on line 28

Warning: Cannot add header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php:215) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/header.inc.php on line 29

Warning: Cannot add header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php:215) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/header.inc.php on line 30

Warning: Cannot add header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/read_dump.php:215) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/header.inc.php on line 32

No SQL query!

--

Suggestions?

Andrew

Dirk, Is that "enclose field names" option part of MySQL or PHPMyAdmin? I am currently trying to store a DB that uses Geekary, and it bombs out on my because of the field names. Help! thanks, -Alan

It's an option for the mysqldump program. Try adding -Q to the command line in admin/database.php (this will be configurable in Geeklog 1.3.8, btw). bye, Dirk