how to take backup and restore file of mysql in php

It is for static page, dynamic page, website, SEO, performance and other web development discussion
denish
Posts: 32
Joined: Fri Sep 19, 2014 5:34 am
Contact:

how to take backup and restore file of mysql in php

Postby denish » Wed Oct 15, 2014 9:47 am

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


Guest

Re: how to take backup and restore file of mysql in php

Postby Guest » Sun Oct 19, 2014 9:30 am

To backup: BACKUP TABLE tbl_name[,tbl_name…] TO
'/path/to/backup/directory'
RESTORE TABLE tbl_name[,tbl_name…] FROM '/path/to/backup/directory'mysqldump: Dumping Table Structure and DataUtility to dump a database or a collection of database for backup or
for transferring the data to another SQL server (not necessarily a MySQL
server). The dump will contain SQL statements to create the table and/or
populate the table.
-t, –no-create-info
Don't write table creation information (the CREATE TABLE statement).
-d, –no-data
Don't write any row information for the table. This is very useful if
you just want to get a dump of the structure for a table!


Return to “PHP, HTML, MYSQL and Web Hosting”

Who is online

Users browsing this forum: No registered users and 3 guests