Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Plugins/Modules/Addons

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #211  
Old 14th April 2014, 17:30
Jorge QWASS Jorge QWASS is offline
Junior Member
 
Join Date: Apr 2012
Posts: 4
Thanks: 3
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by clttech View Post
When I tried to restore a db I get the following error
mysql: unknown option '-x'

I used this command backupres db mydata 2014-03-22 /

Any ideas?

I was able to restore the database by extracting that one database file and running the import command.

mysql -u root -p mydatabase < mydata.sql
I have just got the same error trying to recover some databases. So I have downloaded the last back-res.sh version just to recover with that script and it worked.

I you just want to fix the recovery part from the script without updating it with all new changes provided by Vrij, then update the code around line 547 with just a section of Vrij script (v.5.6):

Code:
            
for i in $arh ; do
  rdb=`echo $i | cut -d "-" -f2`
    mysql --user="$dbuser" --password="$dbpassword" --execute "CREATE DATABASE IF NOT EXISTS $rdb;"
    $BZIP2 -dc $BACKUPDIR/$YDATE-$MDATE/$i | $TAR -xvO | mysql --user="$dbuser" --password="$dbpassword" --da    tabase=$rdb
  done
echo -en "All restore jobs done!\nDatabase $2 restored to date $3!\n"
Add also this in variables section:

Code:
BZIP2=`which bzip2`                                     # name and location of bzip2
And the back-res.sh witl start to import databases.

I would like to thank you Vrij because I was having problems to fix that importing feature and he saved me. Thanks!

Last edited by Jorge QWASS; 15th April 2014 at 10:23.
Reply With Quote
The Following User Says Thank You to Jorge QWASS For This Useful Post:
maximufrancesa9928 (8th June 2014)
Sponsored Links
  #212  
Old 15th May 2014, 23:59
greg.phillipson greg.phillipson is offline
Junior Member
 
Join Date: May 2014
Location: England
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default First time ISP Config 3, first time back up.

Hi,

Just to set the tone, I decided it was time to take the leap of faith and host my own websites, I tried a could of things before I settles on a Dell R200 and ISP3. Which ran for about 3 months before I decided I needed a backup. I bought a QNAP and I have set it to auto backup, however I still get the following, for all databases.

c4wp.wp_usermeta
note : Table does not support optimize, doing recreate + analyze instead

I guess from the other posts this is normal???

I also get

mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES
/bin/tar: /www: Cannot stat: No such file or directory
/bin/tar: Exiting with failure status due to previous errors


This is the bit I don't get is everything working okay?

Cheers
Greg
Reply With Quote
  #213  
Old 7th June 2014, 12:16
greg.phillipson greg.phillipson is offline
Junior Member
 
Join Date: May 2014
Location: England
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ???

Hi,

Can anyone help me out with these errors please? Or am I missing a trick and this is old hat now?

Cheers
Greg
Reply With Quote
  #214  
Old 8th June 2014, 00:14
frprim frprim is offline
Member
 
Join Date: Apr 2014
Posts: 65
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Same error here. Hope someone has a solution for this one.
Im using Ubuntu 12.04LTS
Reply With Quote
  #215  
Old 5th July 2014, 13:12
go0ogl3 go0ogl3 is offline
Member
 
Join Date: Jul 2008
Posts: 73
Thanks: 5
Thanked 39 Times in 6 Posts
Smile Answers

Quote:
Originally Posted by greg.phillipson View Post
Hi,

Just to set the tone, I decided it was time to take the leap of faith and host my own websites, I tried a could of things before I settles on a Dell R200 and ISP3. Which ran for about 3 months before I decided I needed a backup. I bought a QNAP and I have set it to auto backup, however I still get the following, for all databases.

c4wp.wp_usermeta
note : Table does not support optimize, doing recreate + analyze instead

I guess from the other posts this is normal???

I also get

mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES
/bin/tar: /www: Cannot stat: No such file or directory
/bin/tar: Exiting with failure status due to previous errors


This is the bit I don't get is everything working okay?

Cheers
Greg
- The back-res script is trying to optimize tables (like a defrag) but not all database tables suport this - the "error" is normal
- The other mysqldump errors can be ignored too
- The last error can be a problem if the directory /www exists. If you don't have /www please remove it from the script configuration section.

- Maybe, please check the backup files to see for yourself. They are simple archives.
__________________
__________________
go0ogl3
--
Keep your work safe. Better backup than sorry! Download the latest version of the backup and restore script. See more info here.
Reply With Quote
  #216  
Old 15th July 2014, 12:13
sageman sageman is offline
Junior Member
 
Join Date: Feb 2006
Posts: 24
Thanks: 2
Thanked 2 Times in 1 Post
Default Domain Symlinks

Hi,

thank you for the script, it has been working flawlessly over the last few years.

I have just switched to version 0.9.6 -mainly because it saves all web folders separately and it is much easier to restore files for one client only.

One problem I see on my setup (ISPConfig 3 - Debian 7 Perfect Setup) :
the script also archives symlinks in /var/www/ .

So, for example, I see
full_var_www_clients_client0_web1-2014-07-15.tar.bz2
AND the corresponding domain.tld (which is the same project)
full_var_www_domain.tld-2014-07-15.tar.bz2

The second tar is only a few bytes, basically containing folders and the symlink entry : !domain.tld

Is there a way to tell the script to ignore the symlinks?

Or, even better would be, to save project files under the corresponding domain.tld tar...

-Richard
__________________
Richard Dvořk
Reply With Quote
  #217  
Old 21st July 2014, 13:30
Vrij Media Vrij Media is offline
Junior Member
 
Join Date: Jan 2014
Posts: 5
Thanks: 0
Thanked 5 Times in 2 Posts
Default

Ignoring the symlinks is not a good idea. For instance, if you accidentally delete a website abc.com, how would you know which client and which web that is?

It would look cleaner if all files for 1 website is in 1 tar file but it would need a lot of work to make that happen cleanly. I see no disadvantages with the current setup so may I ask you:

Why?
Reply With Quote
  #218  
Old 23rd July 2014, 15:23
sageman sageman is offline
Junior Member
 
Join Date: Feb 2006
Posts: 24
Thanks: 2
Thanked 2 Times in 1 Post
 
Default

Quote:
Originally Posted by Vrij Media View Post
For instance, if you accidentally delete a website abc.com...
True, except that symlinks can be recreated in ISPConfig. Plus I have additionally saved this sort of information off-server. But you are right, the saved symlink can be helpful.

Quote:
Originally Posted by Vrij Media View Post
Why?
Well, initially I just thought it might be a bit tidier . But yes, I realize now that this would be quite a bit of work and in the end you would end up with a file structure that differs from the server file structure.

Thank you for your thoughts, this has cleared thinks up for me.

- Richard
__________________
Richard Dvořk
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
freebsd 7, samba 3, domain controller alexdimarco Suggest HOWTO 6 5th November 2010 16:54
how to restore Ispconfig from backup db na0lb Installation/Configuration 4 24th September 2008 08:51
Restore backup ISPConfig leeeonardo General 4 18th April 2007 20:21
Restore ispconfig complete backup statiic General 1 15th January 2007 10:32
Backup restore on ispconfig misterm Installation/Configuration 0 18th December 2005 23:32


All times are GMT +2. The time now is 07:59.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.