Results 1 to 4 of 4

Thread: Simple mysql questions

  1. #1

    Simple mysql questions

    I run an online application that has a mysql database back-end. It has a feature that provides mqsql database backup from the web-based interface. Here are the options that I see, but I'm not sure what they mean, hence the questions.....

    Structure only
    Structure and data (I use this one)
    Data only

    There are the checkboxes in front of the following options:
    Complete inserts
    Extended inserts
    Use backquotes with tables and fields names
    Save as file ( 'zipped' 'gzipped' )
    WHAT SHOULD I CHECK HERE, SHOULD I CHECK THEM ALL?




  2. #2

    Re:Simple mysql questions

    phpMyAdmin?
    Not sure about these either.
    Structure only
    Structure and data (I use this one)
    Data only
    I guess Structure is just the layout. Data being the data without the layout. Structure & Data being the layout and data; this being the one I usa also. I leave everything unchecked and save as a regular file. My database is currently only 1MB, so there is no need to compress it. If I had a larger DB, I may consider compressing it.



  3. #3
    Mentor coltrane's Avatar
    Join Date
    May 2001
    Location
    North Carolina
    Posts
    1,390

    Re:Simple mysql questions

    Structure only
    Structure and data (I use this one)
    Data only

    There are the checkboxes in front of the following options:
    Complete inserts
    Extended inserts
    Use backquotes with tables and fields names
    Save as file ( 'zipped' 'gzipped' )
    Structure and data [glow=red,2,300]check[/glow]
    Complete inserts [glow=red,2,300]check[/glow]
    if you need to restore the database, this makes it brainless
    Use backquotes with tables and fields names [glow=red,2,300]check[/glow]
    this is must

  4. #4

    Re:Simple mysql questions

    Which software should I use if I want to back up MySQL to teh tape drive? (Should install MySQL agents on the box running MySQL, the same way I use MS SQL agents with Arcserve?)

    Thanks.

Similar Threads

  1. Problem starting mysql conflicts with the RPM "mysql-5.0.27-1.fc6"
    By kamakshiganesh in forum Redhat / Fedora
    Replies: 2
    Last Post: 10-26-2007, 04:35 AM
  2. A Simple Song
    By in forum General Chat
    Replies: 2
    Last Post: 01-29-2005, 09:45 PM
  3. Samba - Simple questions
    By markwaugh in forum Linux - General Topics
    Replies: 2
    Last Post: 12-17-2004, 01:47 PM
  4. some simple YUM questions
    By elovkoff in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 08-04-2004, 11:46 PM
  5. Please help-Should be simple
    By M_A_G_I_C in forum Mandriva
    Replies: 8
    Last Post: 12-03-2002, 01:02 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
  •