Welcome to Geeklog Saturday, October 16 2021 @ 08:30 am EDT

Geeklog Forums

strange backup error/issue


Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
when using the backup utility, as i have often on other gl sites, on this new one i've just set up, the backup creates a file, but...

all that is in the file is info about the mysqldump program and a list of the available options. what's up with that?
it's as if it's reading -Q as -?.

any ideas?

oh, btw, i got rid of the -Q and it backed up, but i dunno if that was such a good idea or not. I'd still like to know why that was that way...
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
The -Q option sets all field and table names in quotes in the SQL dump. There are one or two plugins out there that use special characters in their table names and therefore, those names need to be enclosed in quotes.

However, some (older?) versions of mysqldump don't seem to support the -Q option.

Make sure you can restore the backup you've created. If that works, you should be fine.

bye, Dirk
 Quote

All times are EDT. The time is now 08:30 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