Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Programming/Scripts

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 3rd March 2011, 19:55
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,138
Thanks: 4
Thanked 52 Times in 48 Posts
Default

the first is normal... not sure about the second one. Running out of diskspace? is tht db damaged?
__________________
"Common sense is not as common as commonly believed" by sjau

Auto-Install Script for ISPConfig and Horde on a Vanilla Debian Stable

Need more Repos for Ubuntu? Repository Generator
Need more Repos for Debian? Debian Repository Generator
Reply With Quote
Sponsored Links
  #12  
Old 3rd March 2011, 19:58
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,257
Thanks: 75
Thanked 22 Times in 18 Posts
Default

the second might be a hardware problem. just did a hardware test through my provider and they are going to replace some hardware.

why would the first one be normal? I read that the information schema shouldn't be dumped by default anyway !?

Does this mean the first error doesn't affect my backups?

i.e.
Quote:
mysqldump does not dump the INFORMATION_SCHEMA database by default. As of MySQL 5.1.38, mysqldump dumps INFORMATION_SCHEMA if you name it explicitly on the command line, although currently you must also use the --skip-lock-tables option. Before 5.1.38, mysqldump silently ignores INFORMATION_SCHEMA even if you name it explicitly on the command line.
Reply With Quote
  #13  
Old 30th March 2011, 13:01
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,138
Thanks: 4
Thanked 52 Times in 48 Posts
Default

the command looks up all databases including the INFORMATION_SCHEMA and tries to dump it.

You see, first is an command issued that build a list of the dbs in mysql and then it loops through that list and dumps each one to an own .sql file.
__________________
"Common sense is not as common as commonly believed" by sjau

Auto-Install Script for ISPConfig and Horde on a Vanilla Debian Stable

Need more Repos for Ubuntu? Repository Generator
Need more Repos for Debian? Debian Repository Generator
Reply With Quote
  #14  
Old 30th March 2011, 13:01
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,138
Thanks: 4
Thanked 52 Times in 48 Posts
Default

the command looks up all databases including the INFORMATION_SCHEMA and tries to dump it.

You see, first is an command issued that build a list of the dbs in mysql and then it loops through that list and dumps each one to an own .sql file.
__________________
"Common sense is not as common as commonly believed" by sjau

Auto-Install Script for ISPConfig and Horde on a Vanilla Debian Stable

Need more Repos for Ubuntu? Repository Generator
Need more Repos for Debian? Debian Repository Generator
Reply With Quote
The Following User Says Thank You to sjau For This Useful Post:
Ovidiu (2nd April 2011)
  #15  
Old 21st June 2011, 15:25
eyeoncomputers eyeoncomputers is offline
Junior Member
 
Join Date: May 2011
Posts: 17
Thanks: 0
Thanked 1 Time in 1 Post
 
Default

this is a little shifty but...you may be able to do an ls of /var/lib/mysql and scoop up the dbs in there, and exclude the ones you don't want, but include everything else.
__________________
Solaris ZFS How To
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
Backup of Client Webspaces and Databases JohnSmith Feature Requests 5 2nd July 2007 08:53
Spam Databases plucchetti Installation/Configuration 4 6th March 2006 23:09
website's databases names Prompt General 2 19th October 2005 09:54
Rename Databases AngelDrago Installation/Configuration 2 18th October 2005 06:01


All times are GMT +2. The time now is 21:50.


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