7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

MySql Table Backup

by mohamedismail
6 replies
How can we take a backup of a MySQL table and how can we restore
it?
#backup #mysql #table
  • Profile picture of the author Andrew H
    Most hosts have phpmyadmin installed, so it is very easy.

    Check out this link (first google result for 'phpmyadmin import export')

    Import and export databases using phpMyAdmin - TechRepublic
    Signature
    "You shouldn't come here and set yourself up as the resident wizard of oz."
    {{ DiscussionBoard.errors[8584550].message }}
  • Profile picture of the author webzie
    If you are using wamp server you can use phpmyadmin to take backup of the database, You can export it to sql file and later you can import it.
    {{ DiscussionBoard.errors[8586333].message }}
  • Profile picture of the author ernestrategos
    You have many choices, if you are using Wordpress you can install a plugin and voilà, you have an instant snapshot of your whole database or chosen tables ready for download.

    Of course as Andrew H and webzie mentioned you can always perform a MySQL dump from within phpMyAdmin.

    You also have a plethora of online services and software to make the backup easier and even automatic.

    Greatest of luck
    Signature

    Read one of my latest blog posts:
    https://www.eagleblogging.com/write-...ost-today.html

    {{ DiscussionBoard.errors[8586686].message }}
  • Profile picture of the author RobinInTexas
    You can use Xcloner There's a plugin for WordPress, or it has a stadalone program.
    Signature

    Robin



    ...Even if you're on the right track, you'll get run over if you just set there.
    {{ DiscussionBoard.errors[8589105].message }}
  • Profile picture of the author WebdevelopmentGroup
    Thats a stuff one to do my friend send me a PM I (THINK) I may have a tutorial for you.

    WILL -
    Signature
    WebDevelopmentGroup NYC & CA- Small Business Web Development, App Development, WordPress Development, Graphic Designs, Online Marketing, Local Marketing & more!. "Call us 1.800.219.1314 or message us!". Visit us today! "Now On Live Chat Mon-Fri.". www.WebDevelopmentGroup.org
    (Whitelable our Services)
    ===================================
    ==> #1 OFFLINE MARKETING FORUM ON THE WEB! <==
    www.OFFLINEMARKETINGFORUM.com     (Register Now)
    {{ DiscussionBoard.errors[8589626].message }}
  • Profile picture of the author HybridMarketing
    As was said previously PHPMyAdmin is the simplest way of doing this. It is generally installed on most shared hosts.

    If you are using a VPS you can either do a mysqldump via SSH or install PHPMyAdmin and continue through that.

    PHPMyAdmin allows you to download your MySQL database, and upload an existing backup file. All from within your browser.

    If you have any questions, feel free to send me a PM.
    {{ DiscussionBoard.errors[8593756].message }}

Trending Topics