How to export certain rows of a MySQL table using where clause from a PHP script?
I have a MySQL say test and I want to use a PHP script to create an importable .sql file for rows with ids between 10 and 100.
I want to create a sql file test.sql, which can be imported into a MySQL database.
My code:
$con=mysqli_connect("localhost", "root","","mydatabase"); $tableName = 'test'; $backupFile = '/opt/lampp/htdocs/practices/phpTest/test.sql'; $query = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName WHERE id BETWEEN 10 AND 500"; $result = mysqli_query($con,$query);
This creates a test.sql file but when I try to import it gives error #1064.
My script simply creates a file with rows containing column names and table structure or insert query.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Go to your phpMyAdmin in a very easy way Select the database whose specific rows you want to export Click SQL (run a SQL query on the database) Write sql query and execute it Just like select * from test table limit 500, what will be the result now? Just see "Query Result Operation" at the bottom Just clickExport
Completed:-)
As mentioned in the comments, you can use mysqldump in the following ways.
If you want it to appear in your php file you can do the following
exec('mysqldump --user=... --password=... --host=... DB_NAME --where= > /path/to/output/file.sql');