www.webdeveloper.com
Results 1 to 3 of 3

Thread: backup mysql tables and data

  1. #1
    Join Date
    Jun 2003
    Location
    London
    Posts
    14

    backup mysql tables and data

    Hi all, i am in the process of building a database but i wanted to know what is the best way of backing it up? Someone mentioned to me that i could use excel to make the tables and import to mysql, how would i do this? Also could this technque be applied to the actual data to be stored in the tables?

    thanks

    ceanth

  2. #2
    Join Date
    Feb 2003
    Location
    Britain
    Posts
    1,335
    As far as I know, you will need some third-party software to convert excel files to mysql format and communicate with the server. That isn't going to be free!
    To do it for free, you would be best of with some PHP code that goes through the database, and converts all of the entries to the PHP code which will add them to a new database. Then, you can just save this as a PHP file, and when you want to restore a backup, you just upload and run this file.

    Some hosts do backup the database for you. If yours does, this is probably at no extra cost and a high quality backup. You should email them.

  3. #3
    Join Date
    Feb 2003
    Location
    Derby, UK
    Posts
    456
    It depends what access you have to the database. If you have direct access you can use a mysql gui or just mysqldump command to generate a backup file, if you have myphpadmin access that also allows you to export and download data and/or structure of one or more tables.

    It should be possible to import data from excel, but there is nothing in particular to recommend this method over any other afaik and certainly when it comes to creating the table structure you will want to write the sql for it, not rely on a conversion from something like excel, or you will probably end up with all your fields of inappropriate types + no indexes etc.

    HTH,

    Dai

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles