List:General Discussion« Previous MessageNext Message »
From:SciBit MySQL Team Date:January 1 1970 12:00am
Subject:RE: Re: [OT] PostgreSQL / MySQL Data Dictionary
View as plain text  
> mysqldump --no-data --all-databases
> ____________________________________________________________
> <SNIP>
> Eamon Daly

Yeap Eamon, as mentioned MyRun is not the only utility on earth with the functionality. 
The difference between mysqldump and MyRun is that while MyRun includes all the mysqldump
functionality, MyRun can take ANY source script.

Let's make an example: mysqldump is great for backuping up complete database(s) with or
without data.  This is ofcourse nice, except when you have 50M records in a table,
because then you get a resulting script which is huge.  So essentially they both do
something like this to generate the insert record sql for data backup purposes:

select * from accounts; -- as an example

but because you can customize the source sql script for MyRun, you can go like:

select * from accounts where AccountDate>YEAR(CURDATE()); --

i.e. limit the inserts you going to get to that which is really important.  Also because
it takes a source script, you can essentially limit the tables in a specific database to
those with the important stuff in which you want to backup:
---
use this-db;
select * from accounts; -- Yes, important
select * from orders; -- Yes, important
-- select * from sessions; -- No skip this table completely
select * from logs limit 0; -- Data not important, only capture schema
..
-- Maybe do a little maintenance while we are busy?
update accountpasswords set AccPassword=encrypt(AccPassword) where
AccOpenDate>CURDATE(); 
select * from accountpasswords;
..
use that-db;
select * from ...etc etc
---
The logs table is a good example of such tables, it contains temporary kind of data and
potentially a huge amount,ex. millions of recs.  This will unnecessarily bloat the
destination script file, so we limit it.  Honestly, your backups is only limited by your
imagination.

Kind Regards
SciBit MySQL Team
http://www.scibit.com


Thread
Difference between PostgreSQL and MySQLEWAGW10 Aug
  • Re: Difference between PostgreSQL and MySQLBrad Tilley10 Aug
    • Re: Difference between PostgreSQL and MySQLJosh Trutwin10 Aug
      • Re: Difference between PostgreSQL and MySQLJochem van Dieten10 Aug
        • Re: Difference between PostgreSQL and MySQLJosh Trutwin11 Aug
          • Re: Difference between PostgreSQL and MySQLJochem van Dieten11 Aug
            • Re: [OT] PostgreSQL / MySQL Data DictionaryJosh Trutwin11 Aug
              • Re: [OT] PostgreSQL / MySQL Data DictionaryJochem van Dieten11 Aug
                • MySQL Data Dictionary (INFORMATION_SCHEMA)Jim Winstead11 Aug
                  • Re: MySQL Data Dictionary (INFORMATION_SCHEMA)Jochem van Dieten11 Aug
                  • Re: MySQL Data Dictionary (INFORMATION_SCHEMA)Josh Trutwin11 Aug
          • Changing Fulltext defaults in Win32leegold11 Aug
  • Re: Difference between PostgreSQL and MySQLJochem van Dieten10 Aug
  • Re: Difference between PostgreSQL and MySQLEWAGW10 Aug
  • Re: Difference between PostgreSQL and MySQLSGreen10 Aug
    • Re: Difference between PostgreSQL and MySQLMartijn Tonies10 Aug
    • Re: Difference between PostgreSQL and MySQLJochem van Dieten10 Aug
      • Re: Difference between PostgreSQL and MySQLJosh Trutwin11 Aug
  • Re: Difference between PostgreSQL and MySQLMartijn Tonies10 Aug
  • Re: Difference between PostgreSQL and MySQLEWAGW10 Aug
  • Re: Difference between PostgreSQL and MySQLEWAGW10 Aug
  • Re: Difference between PostgreSQL and MySQLEWAGW10 Aug
  • Re: Difference between PostgreSQL and MySQLmos11 Aug
    • RE: Difference between PostgreSQL and MySQLLachlan Mulcahy11 Aug
      • On the licensing once againDebugasRu11 Aug
        • Re: On the licensing once againZak Greant11 Aug
        • RE: On the licensing once againLachlan Mulcahy11 Aug
          • R: On the licensing once againLeonardo Francalanci11 Aug
            • Re: R: On the licensing once againDebugasRu11 Aug
              • RE: R: On the licensing once againLachlan Mulcahy11 Aug
          • Re: On the licensing once againIssac Goldstand12 Aug
            • Re: On the licensing once againZak Greant12 Aug
  • Converting access to mysql dbEWAGW11 Aug
  • Re: Changing Fulltext defaults in Win32Cemal Dalar11 Aug
    • Re: Changing Fulltext defaults in Win32leegold11 Aug
  • Re: Changing Fulltext defaults in Win32Cemal Dalar11 Aug
  • Re: [OT] PostgreSQL / MySQL Data DictionaryPeter  Brawley11 Aug
    • RE: Re: [OT] PostgreSQL / MySQL Data DictionarySciBit MySQL Team11 Aug
      • Re: [OT] PostgreSQL / MySQL Data DictionaryEamon Daly11 Aug
        • RE: Re: [OT] PostgreSQL / MySQL Data DictionarySciBit MySQL Team12 Aug
          • Re: [OT] PostgreSQL / MySQL Data DictionaryEgor Egorov12 Aug
            • RE: [OT] PostgreSQL / MySQL Data DictionarySciBit MySQL Team12 Aug
Re: On the licensing once againZak Greant11 Aug
Re: On the licensing once againLachlan Mulcahy11 Aug
  • R: On the licensing once againLeonardo Francalanci11 Aug
    • Re: R: On the licensing once againSantino11 Aug
      • Re: R: On the licensing once againZak Greant12 Aug
    • Re: R: On the licensing once againZak Greant12 Aug
Re: On the licensing once againLeonardo Francalanci11 Aug
  • Re: On the licensing once againRich Lafferty11 Aug
Re: [OT] PostgreSQL / MySQL Data DictionarySciBit MySQL Team12 Aug