Author Topic: Backup not working (Read 2275 times)

siteup · « **on:** July 18, 2004, 12:49:06 am »

Just updated LM to 1.77b. I'm trying to write a backup file of my db right now. When I click the 'Write Backup File' button, the page quickly refreshes but no file is written. I think this worked before the upgrade.

DW · « **Reply #1 on:** July 24, 2004, 11:26:49 am »

There seems to be a bug in the mysql detection process on some servers.

Try setting the $sqlpath variable in config.php to different paths, most common:

$sqlpath = '/usr/bin/';

or

$sqlpath = '/usr/local/bin/';

or

$sqlpath = '/usr/local/mysql/bin/';

BGSWebDesign · « **Reply #2 on:** August 04, 2004, 07:54:23 pm »

Hi,

Yep, that fixed it for me, thanks

bhl007 · « **Reply #3 on:** February 21, 2005, 01:57:44 am »

not sure if the latest version have added the more path for backup..

"Try setting the $sqlpath variable in config.php to different paths, most common:
$sqlpath = '/usr/bin/';
$sqlpath = '/usr/local/bin/';
$sqlpath = '/usr/local/mysql/bin/'; "

If haven't, just add into it in future released, to make it more perfect for user that buy in future and having same problem :lol:

andrew · « **Reply #4 on:** March 16, 2005, 10:23:53 pm »

Does anyone know if this has been fixed in the latest release?

Thanks,
Andrew

DW · « **Reply #5 on:** March 17, 2005, 01:38:19 am »

Andrew, the latest distribution files should have the latest detection code. It may need to be improved further.

Regards

mike2 · « **Reply #6 on:** March 17, 2005, 09:21:33 am »

Just a quick note about my experience a while back I tried to move my db over to another server with the backup then restore and some stuff was missing (like follow up sequences, minor stuff only).

It worked best for me just to copy the mysql DB on the server that way everything came over. This was a while back so maybe it's better in the newer versions...

DW · « **Reply #7 on:** March 17, 2005, 03:55:35 pm »

I just finished some code for the update that checks the backup file to make sure no tables are missing. It also uses a new loop to extract each table individually so that not as much is happening with each command (which is probably what causes the loss of data).

Regards!

andrew · « **Reply #8 on:** March 17, 2005, 10:24:58 pm »

Dean that's great! Back up is key- Thanks for looking into this.
Andrew