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
  #201  
Old 23rd January 2014, 12:59
Vrij Media Vrij Media is offline
Junior Member
 
Join Date: Jan 2014
Posts: 4
Thanks: 0
Thanked 5 Times in 2 Posts
Default

Quote:
Originally Posted by sjswarts View Post
Couldn't you just stipulate exactly what you wanted in /var to be backed up to prevent double backups?

For example instead of backing up /var try to backup the following:

/var/vmail
/var/www
/var/*whatever*else*
Today I was in need of restoring 1 particular website. Unfortunately because back-res can't handle that I had to restore /var to a temp dir (which takes long time).

While waiting on the backup to extract I scripted the modifications needed to:
- Removed /var from DIRECTORIES
- Added code to add all subdirectories of /var excluding /var/www and /var/vmail
- Added code to add /var/www excluding subdirectories of /var/www/clients, all subdirectories of /var/www/clients and all subdirectories of /var/vmail

Script is ready and I am testing now. Would go0ogl3 be interested in a proper diff against 0.9.4?
Reply With Quote
The Following User Says Thank You to Vrij Media For This Useful Post:
till (23rd January 2014)
Sponsored Links
  #202  
Old 23rd January 2014, 13:23
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,647
Thanks: 794
Thanked 5,003 Times in 3,912 Posts
Default

When you have a improved version of the script, then it would be nice if you post it here in the thread.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #203  
Old 24th January 2014, 18:46
Vrij Media Vrij Media is offline
Junior Member
 
Join Date: Jan 2014
Posts: 4
Thanks: 0
Thanked 5 Times in 2 Posts
Default

Unfortunately it doesn't work as intended yet. I will post a new script as soon as I have tested extensively.
Reply With Quote
  #204  
Old 25th January 2014, 17:15
Vrij Media Vrij Media is offline
Junior Member
 
Join Date: Jan 2014
Posts: 4
Thanks: 0
Thanked 5 Times in 2 Posts
Default

In the zipfile attached you will find 2 files:
- a patch against the unmodified 0.9.4 version
- a new version of the script which I have numbered 0.9.5, It would be nice if go0ogl3 would put this on his website so that we dont have cluttered versions.

Please use at your own risk and have fun with it.
Attached Files
File Type: zip back-res.zip (8.9 KB, 28 views)
Reply With Quote
  #205  
Old 1st February 2014, 17:06
shibble shibble is offline
Junior Member
 
Join Date: Oct 2011
Location: Zwolle, Netherlands
Posts: 19
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by bluebirdnet View Post
Anyone have an idea why i would be getting this error ? The mysqlcheck runs fine with root credentials and i can login to mysql from shell using root.



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

Same problem here, except:
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES

it stops after the warning =x


anybody who can help me out?
Reply With Quote
  #206  
Old 4th February 2014, 14:36
Vrij Media Vrij Media is offline
Junior Member
 
Join Date: Jan 2014
Posts: 4
Thanks: 0
Thanked 5 Times in 2 Posts
Default

Quote:
Originally Posted by fino View Post
cat back-res |grep -i /bin/tar
TAR="/bin/tar" # name and location of tar

mysql: unknown option '-x'
+ for i in '$arh'
++ echo db-c23web-2014-01-05.tar.bz2
++ cut -d - -f2
+ rdb=c23web
+ mysql -uroot -pxxx c23web -xvjp /bck/test.test.it/2014-01/db-c23web-2014-01-05.tar.bz2
mysql: unknown option '-x'

Is the same
Attached a new version which addresses this issue.

# -----------------------------------------------------------------------------
# version 0.9.6 - 2014-02-04 (by Yavuz Aydin - Vrij Media)
# --------------------------
# - Changed mysql import routine to create database if it doesn't exist
# - Changed code to import database
Attached Files
File Type: zip back-res.zip (7.7 KB, 36 views)
Reply With Quote
The Following 4 Users Say Thank You to Vrij Media For This Useful Post:
Farsus (5th February 2014), go0ogl3 (4th March 2014), Jorge QWASS (14th April 2014), till (4th February 2014)
  #207  
Old 13th February 2014, 17:08
robin99 robin99 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 12
Thanks: 1
Thanked 0 Times in 0 Posts
Default

When trying to perform a restore with the original script at http://www.eurosistems.ro/back-res

I get the following error:

Code:
    You want to restore dir all to date 2014-02-13.

Please input "yes" if the above is ok with you and press [ENTER]: yes

Extracting all dir's backup from date 2014-02-13 to /:
touch: cannot touch `/tmp/tmpbck/datestart': No such file or directory
touch: cannot touch `/tmp/tmpbck/dateend': No such file or directory
find: `/tmp/tmpbck/datestart': No such file or directory
find: `/tmp/tmpbck/datestart': No such file or directory
find: `/tmp/tmpbck/dateend': No such file or directory


---------------------=== The back-res script by go0ogl3 ===---------------------
Any ideas?

It seems it is not picking up the first possible restore date that it can use?
Reply With Quote
  #208  
Old 13th February 2014, 17:13
robin99 robin99 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 12
Thanks: 1
Thanked 0 Times in 0 Posts
Default

OK fixed it, as it was on a new machine it didn't have the /tmp/tmpbck folder

had to:

mkdir /tmp/tmpbck

Currently restoring.
Reply With Quote
  #209  
Old 4th March 2014, 19:06
go0ogl3 go0ogl3 is offline
Member
 
Join Date: Jul 2008
Posts: 69
Thanks: 4
Thanked 38 Times in 6 Posts
Default Updated to latest version 0.9.6

Hello,

I've updated the link to the latest version 0.9.6 - 2014-02-04 (thanks Yavuz Aydin - Vrij Media)
The script is available at:

http://www.eurosistems.ro/back-res

old versions:

http://www.eurosistems.ro/back-res.0.9.1
http://www.eurosistems.ro/back-res.0.9.2
http://www.eurosistems.ro/back-res.0.9.3
http://www.eurosistems.ro/back-res.0.9.4
http://www.eurosistems.ro/back-res.0.9.5.zip
http://www.eurosistems.ro/back-res.0.9.6.zip

P.S.:
I'm using a version of this script to backup firebird databases also, it's mostly hard-coded but if it's usefull to somebody I'll try to make myself some time to adjust the code to make the restore also and to explain how it is working to backup.
__________________
__________________
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
  #210  
Old 24th March 2014, 19:46
clttech clttech is offline
Junior Member
 
Join Date: Mar 2009
Posts: 15
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default restore error for mysql

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
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 03:10.


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