backup script bug (prefixes)

briansol · May 18th, 2008, 05:54 PM

Hi guys.

Just upgraded to 6.1 All is well so far

Question on back ups.... the built in back up generator takes all of miliseconds to run, and every table exports:

Code:

Content visible to verified customers only.

as the .sql file.

Is there something i need to turn on to actually get these to dump my data?

i noticed

Quote:

Host: localhost Database: xxxxxxx_forumuser

perhaps should really be

Code:

Content visible to verified customers only.

is this a bug with table prefixes?

Chuck S · May 18th, 2008, 06:21 PM

What is your actual table prefix in forum settings?

We are using normal mysql command line interfacing so I am not seeing anything wrong there.

I know our little backup utility will not work on every mysql version.

Code:

Content visible to verified customers only.

Chuck S · May 18th, 2008, 06:22 PM

Code:

Content visible to verified customers only.

Thats how we list the tables in your database so they should be correct as mysql is reporting them.

briansol · May 18th, 2008, 06:53 PM

forum_ is my vB prefix.

the dump runs ok...

Quote:

PhotoPost Database Backup

Command being used to execute dumps (specific tables are executed individually):

/usr/bin/mysqldump --opt -h localhost -uXXXXX -pXXXXXX XXXXXcom_forum

Results:

user has been backed up.

You should double-check your .sql files to be sure the backup completed successfully.

but as stated above, nothing actually gets output due to the mis pre-fix

Chuck S · May 18th, 2008, 06:58 PM

Do you have ssh on the server?

Are you able to run that command via shell and see if it works?

briansol · May 18th, 2008, 07:08 PM

yes, it will work, but only with the proper table prefix on it of course