Textpattern CMS support forum

You are not logged in. Register | Login | Help

#41 2005-08-25 15:21:26

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Thanks aba. I was suspicious of that option causing problems. I know at least a few hosts (Textdrive being one) that don’t allow you to lock tables by default. I’ll have to look at making this an option.

Can anyone else having problems confirm that removing the —skip-lock-tables option as aba suggested?

Offline

#42 2005-08-25 15:23:44

aba
Plugin Author
Registered: 2004-04-14
Posts: 119

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

it didn’t work quite the way you said (I think your <code><del></del></code>s were in slightly the wrong place,

As your post indicates, the del sections aren’t from me, they result from the code block parsing… ;)

Glad it worked for you.

Offline

#43 2005-08-25 16:14:20

bauhouse
Plugin Author
From: Abbotsford, BC Canada
Registered: 2004-06-29
Posts: 68
Website

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

I’ve explored the problem for Mac OS X a little more. What opened my eyes to the problem was trying to download the files created by db backup from different browsers. Trying to save the .sql file from Internet Explorer returned the following message:

<pre>
Internet Exploder doesn’t know how to handle the type of file you have selected.
You can choose to save this file to your disk or you can configure a Helper Application for this file.
MIME Type: application/download
File Name: index.php
</pre>

So the file corruption is happening when clicking on the download link because the download link appears to be combining the encoded SQL file and the index.php file. This was confirmed by downloading the same file by FTP (using Transmit 3) from TextDrive and comparing the file downloaded from the db backup tab. The file downloaded by FTP was perfect. The file downloaded from the db backup tab was corrupted. I’ll email you examples.

Offline

#44 2005-08-25 20:07:57

bauhouse
Plugin Author
From: Abbotsford, BC Canada
Registered: 2004-06-29
Posts: 68
Website

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

My local db backup problem in Mac OS X 10.4 — where the db backup tab would save an empty gzipped file or return an “empty file” error — ended up being a command line problem to do with the MySQL install: my default shell could not find the mysqldump command without the full path /usr/local/mysql/bin/mysqldump. This can be solved by editing the plugin. Change the following variable from this:

<pre>$path_to_mysqldump = ‘mysqldump’;</pre>

to this:

<pre>$path_to_mysqldump = ‘/usr/local/mysql/bin/mysqldump’;</pre>

Or to avoid having to modify the plugin everytime you restore your database, change the PATH environment variable in your shell’s login script:

<pre>echo ‘export PATH=/usr/local/mysql/bin:$PATH’ >> ~/.bash_profile</pre>

That is, find the invisible file .bash_profile (for example, with a [free] text editor such as TextWrangler using “File > Open Hidden…”) in the top level directory of your user account and add export PATH=/usr/local/mysql/bin:$PATH to the end of the file.

Last edited by bauhouse (2005-08-25 22:58:53)

Offline

#45 2005-08-25 22:44:51

aba
Plugin Author
Registered: 2004-04-14
Posts: 119

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

wilshire: If you reword the error messages and fix the mysqldump problem you might want to look into this as well:

<code>
delete * from txp_image

0/1 Query(s) Executed Successfully
</code>

Offline

#46 2005-08-25 23:49:36

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

aba – you don’t need the <code>*</code>. try <code>delete from txp_image</code>.

I’ve been working with Stephen (bauhouse) to diagnose a few of the problems people have been having. There’s one that remains to be fixed and then a new version will be posted.

I’ve added the ability to set some preferences for the plugin which should help things as well.

Offline

#47 2005-08-26 04:42:04

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Ok, version 4.0.1 is now up for download.

New additions include the ability to set several preferences to help troubleshoot and solve common problems that will cause your backup/restore to fail. Here are some of the problems that have come up. Thanks to bauhouse for helping to diagnose some of the problems.

  1. Your host doesn’t allow mysql table locking – Change the lock tables preference to “No” and try again. I can tell you of at least one host that is pretty common in these parts (TXD) that doesn’t allow table locking by default.
  2. The path to mysqldump and mysql are not in yoru system path – Set the full path to these executables in the preferences.
  3. Your backup fails and none of the above fixed it – Turn the debug preference on. This will echo the command being run to your screen. Try running it through a command line and post the error message you see.

I also added the ability to set hte backup file path so you can easily change it to a non-public directory.

Offline

#48 2005-08-26 07:22:17

aba
Plugin Author
Registered: 2004-04-14
Posts: 119

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

> wilshire wrote:

> aba – you don’t need the <code>*</code>. try <code>delete from txp_image</code>.

yeah, I know. Sorry, I meant the “0/1 Querys” part – it would be nice to see the error message as well (I tend to use the wrong commands because I forget what I’m working with)

Offline

#49 2005-08-26 11:20:43

Els
Admin
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Do I have to change anything in mysqldump Path and mysql Path?

Offline

#50 2005-08-26 12:07:09

Els
Admin
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Okay, I got it working (partially) on my local install. (Not on the remote server because I don’t know what to set for the mysql paths (see above post), and I don’t know how to run the command from the command line there.

Local:

Backup is working. Restore however gives me this: FAILED TO RESTORE: 1. Running the command that appears in debugging mode from the command line gives this error:

ERROR 1064 at line 3251: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ’1 tinyint(1) NOT NULL default ‘0’, 2 tinyint(1) NOT NULL defa
(this really ends like that)

Remote:

BACKUP FAILED: file not there 127
[Edit] Lock tables yes or no makes no difference.

Last edited by doggiez (2005-08-26 12:11:16)

Offline

Board footer

Powered by FluxBB