MySql restore

[erockguide]

I use a script that someone on this board provided a couple years ago to backup and restore my database. It always worked. Now that everything is flipped to a new server for some reason, I try to restore my most recent backup and I get this:

sh: line 1: /usr/local/bin/mysql: No such file or directory

Your database has been restored.

What does this mean?

Also, my forum no longer has current dates or times, nor does it show active user lists. Any ideas how this could happen. The site is www.erockonline.com

[snowmaker]

The error message is probably from the fact that the new platform computers have a different file structure (file paths) than the computers on the Legacy platform. As I am not familiar with that script, and dont use any forum softwares on my site, I don't really have any answers for you.. Hope this helps!:idea3:

[McoreD]

erockguide,

I am having a similar problem. That someone else is I am assuming Halfabee, and the php script is mysql_utility?

I've also used this great script in the past and all of a sudden with exact inputs, it doesn't seem to work any more.

MYSQL Backup and Restore utility
Doing backup now


You had an error.

Can this be due the new servers at PowWeb? If so, can anybody please suggest a good way to backup/restore databases?

Much appreciated,
McoreD

[McoreD]

Hey Guys,

So mysql_utility doesn't work with the new PowWeb servers?

[extras]

The one I made for the old platform works on the new platform, too,
unless Endurace(PowWeb) has changed some settings.
(It complains about missing /proc file system, but it's just for monitoring
server usage and no effect on the dump/restore operation.)

http://check-these.info/MiniSqlDump.html

[McoreD]

Works GREAT. Thanks extras. :)

[BerksWebGuy]

Just to add, the path has changed to:

/usr/bin/mysql
/usr/bin/mysqldump

[MMF]

cgi1403.int.bizland.net
Error: /proc must be mounted
To mount /proc at boot you need an /etc/fstab line like:
/proc /proc proc defaults
In the meantime, mount /proc /proc -t proc
u='fazza3temp', p='********', h='mysql14.powweb.com', d='fazza3vb', f='http%253A%252F%252Fwww.fazza3.com%252Fsqlbackup %252Fnewib.gz', t='+', r='1' m='1', res=''
gunzip: http%253A%252F%252Fwww.fazza3.com%252Fsqlbackup%25 2Fnewib.gz: No such file or directory
/home/users/web/b2133/pow.myfazza3/htdocs/cgi-bin/minisqldump.cgi: line 236: $ff: ambiguous redirect
Restoring with 'mysql' (backupfile='', decompressed from 'http%253A%252F%252Fwww.fazza3.com%252Fsqlbackup%2 52Fnewib.gz' ) ...
/home/users/web/b2133/pow.myfazza3/htdocs/cgi-bin/minisqldump.cgi: line 249: $ff: ambiguous redirect
Done.
--------------
Show Table Status
--------------

Empty set (0.00 sec)

Bye
Error: /proc must be mounted
To mount /proc at boot you need an /etc/fstab line like:
/proc /proc proc defaults
In the meantime, mount /proc /proc -t proc

[extras]

cgi1403.int.bizland.net
u='fazza3temp', p='********', h='mysql14.powweb.com', d='fazza3vb', f='http%253A%252F%252Fwww.fazza3.com%252Fsqlbackup %252Fnewib.gz', t='+', r='1' m='1', res=''
gunzip: http%253A%252F%252Fwww.fazza3.com%252Fsqlbackup%25 2Fnewib.gz: No such file or directory
/home/users/web/b2133/pow.myfazza3/htdocs/cgi-bin/minisqldump.cgi: line 236: $ff: ambiguous redirect
Restoring with 'mysql' (backupfile='', decompressed from 'http%253A%252F%252Fwww.fazza3.com%252Fsqlbackup%2 52Fnewib.gz' ) ...
/home/users/web/b2133/pow.myfazza3/htdocs/cgi-bin/minisqldump.cgi: line 249: $ff: ambiguous redirect
Done.
You specified URL (http://....) instead of file path.

If you are not sure about the differences, upload the gzipped file into the same directory where
you put the script, and only enter the file name (without directory, nor http://....).

If that's still too difficult, please use the tool provided by powweb and ask their support.

[MMF]

I did that before going to the url way it also did not work, my file is .gz?

[pgac_chris]

I use mysqldumper for backing up and restoring, and that's working fine

http://www.mysqldumper.de/en/index.php

i've used it on databases of 600MB + in size, and although it can take a while
always does the business.

[extras]

I did that before going to the url way it also did not work, my file is .gz?
I guess it depends on how you made the backup/dump file.
The script should be giving you enough information (or more than that)
to trouble shoot if you bother to look into it.

But again, you may want to try other solution if you are not comfortable with the script.
I've written it for someone who needs small and fast solution, and not for everyone.