PHP script for exporting a single table to SQL file

Question

I want to export a single table into an SQL file for backup every day using cron-job.
I've looked around for some scripts bust most were not so user-friendly.

I've seen this: http://help.1and1.com/hosting-c37630/linux-c85098/php-c37728/importing-and-exporting-mysql-databases-using-php-a595887.html

But it exports the whole DB (which weighs about 10GBs), I need to export a single 16mb table.

The preferred method is for it to look like a normal sql file (like the ones Phpmyadmin exports), something like this:

 CREATE TABLE IF NOT EXISTS `parts` (
  `flag` char(1) NOT NULL DEFAULT '',
  `comp` int(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `rname` varchar(255) NOT NULL DEFAULT '',
  `hname` varchar(255) NOT NULL DEFAULT '',

newman · Accepted Answer · 2014-01-01 13:35:35Z

3

You can just change this script and add params for tables name

For example change string

$command='mysqldump --opt -h' .$mysqlHostName .' -u' .$mysqlUserName .' -p' .$mysqlPassword .' ' .$mysqlDatabaseName .' > ~/' .$mysqlExportPath;

to

$command='mysqldump --opt -h' .$mysqlHostName .' -u' .$mysqlUserName .' -p' .$mysqlPassword .' ' .$mysqlDatabaseName .' parts > ~/' .$mysqlExportPath;

Where parts is your table name

answered Jan 1, 2014 at 13:35

newman

2,73419 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris Barrett · Accepted Answer · 2014-01-01 13:40:25Z

1

http://www.tutorialspoint.com/mysql/mysql-database-export.htm

You could either make a bash script, or you could use the exec() php function.

<?php

exec('mysqldump -u XXXX -p XXXX [table_name] > [output file]')

edited Jan 1, 2014 at 13:40

answered Jan 1, 2014 at 13:28

Chris Barrett

5264 silver badges12 bronze badges

2 Comments

Nir Tzezana Over a year ago

I'm guessing "u" is for user and "p" is for password, but shouldn't there be a place to insert the DB itself?

Chris Barrett Over a year ago

Yep -u [username] -p [password] and could prepend the table_name with the db for example database_here.table_name_here

Collectives™ on Stack Overflow

PHP script for exporting a single table to SQL file

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related