| Author |
Message |
pstefano
first backups
Joined: 21 Sep 2011
Posts: 1
|
 Posted:
2011-09-21, 14:16 How to exclude some tables? |
  |
How to exclude some tables? For example: i want all database schema without data from some tables
Thanks for help
|
|
   |
|
Anzeigen
|
|
Posted:
Anzeigen |
|
|
| |
|
Jens_K
Moderator
Age: 37
Joined: 04 Sep 2007
Posts: 1710
Location: Nähe Bielefeld
|
|
Posted:
2011-09-21, 18:03 (No subject) |
|
If you exclude certain tables, your backup will not be complete.
In case you need to restore the DB, the excluded tables will be missing, resulting in a corrupt database.
That's not the purpose of MySQLDumper.
But you can work with prefixes to only backup the tables that start with the given prefix.
If you have many different prefixes, you can work with different configuration profiles where you change the prefix to the wanted value, even a whole table name so your backup will only contain that table.
Another way is to alter the backup script and hard-code into it to ommit certain tables.
_________________
It's like math-camp all over again ... not ... that i've ever been to math-camp!
mein Blog
|
|
 |
|
Lepas
uses MSD regulary
Joined: 27 Aug 2008
Posts: 12
|
|
Posted:
2011-09-23, 13:29 (No subject) |
|
« Jens_K » wrote: If you exclude certain tables, your backup will not be complete.
In case you need to restore the DB, the excluded tables will be missing, resulting in a corrupt database.
That's not the purpose of MySQLDumper.
I understand your point, but the idea to exclude certain tables is to avoid timeout errors and email size limitations in automatic backups. As far as I know, this is the more helping feature of MySQLdumper, but has a critical limitation here if it doesn't allow which tables we want to include in the auto-backups. I mean that excluding tables is not a problem because you could always set another CRON with the missing tables, maybe with a different frequency.
For example, if we run a forum site we could want a main big backup including posts and users table we could set in a daily backup; another one including search wordmatch and robots tables (these ones should be so big and unnecessary in the worst of the cases), let's say we set this auto-backup in a twice a year freq; and finally another backup with the rest of system tables (these usually are small - around 3-5MB), which we could set weekly. Thus, the "complete" backup is solved.
Quote: But you can work with prefixes to only backup the tables that start with the given prefix.
If you have many different prefixes, you can work with different configuration profiles where you change the prefix to the wanted value, even a whole table name so your backup will only contain that table.
I guess most MySQLdumper users work with free Soft for Content and Forums, and they (we) cannot deal with the soft prefixes without causing a mess each time that an update is released.
Quote: Another way is to alter the backup script and hard-code into it to ommit certain tables.
Since we're not programmers, we'd like to know how to do that 
|
|
| |
|
Jens_K
Moderator
Age: 37
Joined: 04 Sep 2007
Posts: 1710
Location: Nähe Bielefeld
|
|
Posted:
2011-09-23, 16:54 (No subject) |
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16070
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-09-23, 18:49 (No subject) |
|
Verified. 
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
 |
|
|
|
CrackerTracker © 2004 - 2012 CBACK.de
Powered by Orion based on phpBB
© 2001, 2002 phpBB Group
CBACK Orion Style based on FI Theme
All times are GMT + 2 Hours
phpBB SEO
|
