Results 1 to 5 of 5

Thread: [RESOLVED] Backup local MySQL database...

  1. Dec 19th, 2005, 08:36 AM #1
    NoteMe
    NoteMe is offline

    Thread Starter
    Retired G&G Mod NoteMe's Avatar
    Join Date
    Oct 2002
    Location
    @ Opera Software
    Posts
    10,190

    Resolved [RESOLVED] Backup local MySQL database...

    Is there any easy way to backup a local MySQL database, so I can transport them to an other PC and upload the tables with the info on that PC too?


    - ØØ -
    Opera Desktop Team Blog
    Reply With Quote Reply With Quote
  2. Dec 19th, 2005, 04:05 PM #2
    visualAd
    visualAd is offline
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: Backup local MySQL database...

    The database is held in a directory and the tables are held in individual files in the data directory for mysql. Therefore, if you make a copy of the database directory you want to back up,, this should be sufficient.

    Remember however, when restoring them, you need to ensure you restore the appropriate permissions on the directory and its files.
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!

    Spread happiness and joy. Rate good posts.
    Reply With Quote Reply With Quote
  3. Dec 19th, 2005, 04:35 PM #3
    NoteMe
    NoteMe is offline

    Thread Starter
    Retired G&G Mod NoteMe's Avatar
    Join Date
    Oct 2002
    Location
    @ Opera Software
    Posts
    10,190

    Re: [RESOLVED] Backup local MySQL database...

    Thanks a bunch...but next time don't bee so rude...
    Opera Desktop Team Blog
    Reply With Quote Reply With Quote
  4. Dec 19th, 2005, 05:33 PM #4
    McCain
    McCain is offline
    Fanatic Member McCain's Avatar
    Join Date
    Jan 2002
    Location
    Sweden/Denmark
    Posts
    802

    Re: [RESOLVED] Backup local MySQL database...

    Or you could export them to textfiles using phpMyAdmin and import them using the same
    Never argue with fools, they will only drag you down to their level, and beat you with experience.

    Q: How do you tell an experienced hacker from a novice?
    A: The latter thinks there's 1000 bytes in a kilobyte, while the former is sure there's 1024 meters in a kilometer
    Reply With Quote Reply With Quote
  6. Dec 19th, 2005, 07:46 PM #5
    PlaGuE
    PlaGuE is offline
    Hyperactive Member PlaGuE's Avatar
    Join Date
    Jun 2005
    Location
    in ur mind.
    Posts
    445

    Re: [RESOLVED] Backup local MySQL database...

    I just export them into .sql files and upload them that way.
    ~~~~~~~~~~~~~~
    Quote Originally Posted by visualAd
    The database is held in a directory and the tables are held in individual files in the data directory for mysql. Therefore, if you make a copy of the database directory you want to back up,, this should be sufficient.

    Remember however, when restoring them, you need to ensure you restore the appropriate permissions on the directory and its files.
    Quote Originally Posted by NoteMe
    Thanks a bunch...but next time don't bee so rude...

    How was he rude


    ????
    Without balance, there could only be chaos.
    Without chaos, there could be no balance.
    I live with karma. Eat with destiny. Dream of life without shackles....
    Yet. If life had no consequences, life could not exist, nor could it flourish.

    If at first you dont succeed.You're screwed.

    C++/Java NOOB.

    I aint a professional at PHP, but if i can help i will.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width