Welcome to Geeklog, Anonymous Monday, January 30 2023 @ 10:17 am EST

Geeklog Forums

Just wish to confirm backing up with phpMyAdmin


Status: offline

vbgunz

Forum User
Full Member
Registered: 01/24/03
Posts: 169
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 Smile
Victor B. Gonzalez -
http://aeonserv.com
 Quote

Status: offline

Dirk

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

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

 Quote

AndyM

Anonymous
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
 Quote

Status: offline

amckay

Forum User
Full Member
Registered: 03/23/02
Posts: 180
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

All times are EST. The time is now 10:17 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