Professional Web Applications Themes

MySQL backup but only soem tables with a prefix - MySQL

One of my friend had to mix 2 kind of tables into the same database 'friend_database' using a different prefix (pre1_tables and pre2_tables ). He would like to backup separatly these 2 kind of tables, but using phpmyadmin he can't (all or one by one selection.... 200 tables) Is there any way to find a script that can do the selective backup ? (then I'll rebuild 2 databases....) thanks for your help Joss...

  1. #1

    Default MySQL backup but only soem tables with a prefix

    One of my friend had to mix 2 kind of tables into the same database
    'friend_database' using a different prefix (pre1_tables and pre2_tables
    ).
    He would like to backup separatly these 2 kind of tables, but using
    phpmyadmin he can't (all or one by one selection.... 200 tables) Is
    there any way to find a script that can do the selective backup ?
    (then I'll rebuild 2 databases....)

    thanks for your help

    Joss

    Josselin Guest

  2. #2

    Default Re: MySQL backup but only soem tables with a prefix

    "Josselin" <josselinwanadoo.fr> wrote in message
    news:441030d7$0$20174$8fcfb975news.wanadoo.fr...
    > One of my friend had to mix 2 kind of tables into the same database
    > 'friend_database' using a different prefix (pre1_tables and pre2_tables ).
    > He would like to backup separatly these 2 kind of tables,
    mysqldump allows optional arguments with which you can specify individual
    tables to back up. I don't think that it supports any kind of
    pattern-matching or wildcards in the table names. You could get a list of
    the tables and use a text editor to create two separate mysqldump commands,
    for the two sets of tables.

    I don't have phpmyadmin installed currently, I'm using MySQL Administrator
    when I use a GUI. In this tool, there is no opportunity to use wildcards
    for table names when making a backup dump. You get to check off specific
    tables.

    Regards,
    Bill K.


    Bill Karwin Guest

  3. #3

    Default Re: MySQL backup but only soem tables with a prefix

    On 2006-03-09 18:53:00 +0100, "Bill Karwin" <billkarwin.com> said:
    > "Josselin" <josselinwanadoo.fr> wrote in message
    > news:441030d7$0$20174$8fcfb975news.wanadoo.fr...
    >> One of my friend had to mix 2 kind of tables into the same database
    >> 'friend_database' using a different prefix (pre1_tables and pre2_tables
    >> ).
    >> He would like to backup separatly these 2 kind of tables,
    >
    > mysqldump allows optional arguments with which you can specify
    > individual tables to back up. I don't think that it supports any kind
    > of pattern-matching or wildcards in the table names. You could get a
    > list of the tables and use a text editor to create two separate
    > mysqldump commands, for the two sets of tables.
    >
    > I don't have phpmyadmin installed currently, I'm using MySQL
    > Administrator when I use a GUI. In this tool, there is no opportunity
    > to use wildcards for table names when making a backup dump. You get to
    > check off specific tables.
    >
    > Regards,
    > Bill K.
    thanks for your support... I have both MySQL Administrator and
    phpmyadmin.... and unfortunatly it's seems to be impossible to
    dump/backup tables based on prefix.... (so why prefix are made for...?)
    200 tables to check... well time to start !

    Joss

    Josselin Guest

Similar Threads

  1. Using CFML to Backup (duplicate) tables into the same orSecond MDB
    By bigbrain28 in forum Coldfusion Database Access
    Replies: 1
    Last Post: October 31st, 09:26 PM
  2. MySQL BackUp - Possible via cfm page?
    By Moss in forum Coldfusion Database Access
    Replies: 0
    Last Post: July 4th, 03:33 PM
  3. php Mysql Backup
    By Roger in forum PHP Development
    Replies: 0
    Last Post: January 5th, 06:22 PM
  4. Backup MySQL DB
    By Jeffrey Silverman in forum PHP Development
    Replies: 5
    Last Post: July 16th, 02:46 PM
  5. MYSQL Backup & Restore using PHP ?
    By James in forum PHP Development
    Replies: 3
    Last Post: July 11th, 11:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139