Jump to content


Photo

Backup of MySql Table


  • Please log in to reply
2 replies to this topic

#1 mohamedismail

mohamedismail

    Young Padawan

  • Members
  • Pip
  • 23 posts
  • Gender:Male

Posted 01 April 2014 - 04:32 AM

How can we take a backup of a MySQL table and how can we restore it?
 

 



#2 ScadlySag

ScadlySag

    Young Padawan

  • Members
  • Pip
  • 1 posts

Posted 06 April 2014 - 11:33 AM



פורטל המשחקים של ישראל -http://gamesweb.co.il/ חדשים. חדש ! כנסו !

#3 ElizabethKeen

ElizabethKeen

    Young Padawan

  • Members
  • Pip
  • 2 posts

Posted 07 November 2014 - 05:05 AM

Back up From the Command Line (using mysqldump)

If you have shell or telnet access to your web server, you can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file. The dump file contains the SQL statements necessary to re-create the database. Here is the proper syntax:

$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
  • [uname] Your database username
  • [pass] The password for your database (note there is no space between -p and the password)
  • [dbname] The name of your database
  • [backupfile.sql] The filename for your database backup
  • [--opt] The mysqldump option

For example, to backup a database named 'Tutorials' with the username 'root' and with no password to a file tut_backup.sql, you should accomplish this command:

$ mysqldump -u root -p Tutorials > tut_backup.sql

 

For Web Apps Design and Development visit http://www.ati-erp.com

ATI-ERP






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users