Easy way to export a SQL table without access to the server or phpMyADMIN

by

You could use SQL for this:

$file="backups/mytable.sql";
$result = mysql_query("SELECT * INTO OUTFILE '$file' FROM `##table##`");

Then just point a browser or FTP client at the directory/file (backups/mytable.sql). This is also a nice way to do incremental backups, given the filename a timestamp for example.

To get it back in to your DataBase from that file you can use:

$file="backups/mytable.sql";
$result = mysql_query("LOAD DATA INFILE '$file' INTO TABLE `##table##`");

The other option is to use PHP to invoke a system command on the server and run ‘mysqldump’:

$file="backups/mytable.sql";
system("mysqldump --opt -h ##databaseserver## -u ##username## -p ##password## ##database | gzip > ".$file);

More Related Contents:

  1. Export MySQL data to Excel in PHP
  2. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  3. Error 1148 MySQL The used command is not allowed with this MySQL version
  4. Laravel – only a zero is saved to the database
  5. storing user_id in session variable
  6. I am seeing this error on submitting form Error: query was empty [closed]
  7. Reference: What is a perfect code sample using the MySQL extension? [closed]
  8. Convert from MySQL datetime to another format with PHP
  9. Passing an array to a query using a WHERE clause
  10. PHP/MySQL Insert null values
  11. Mechanisms for tracking DB schema changes [closed]
  12. Can you add an if statement in ORDER BY?
  13. Import file size limit in PHPMyAdmin
  14. PDO Connection Test
  15. PDO fetch one column from table into 1-dimensional array
  16. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  17. Detect mysql update/insertion failure due to violated unique constraint
  18. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  19. Get all mysql selected rows into an array
  20. How to bind SQL variables in PHP?
  21. PHP – Secure member-only pages with a login system
  22. MySQL ORDER BY IN()
  23. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  24. php password_verify() hash and pass won’t match
  25. PHP mySQL – Insert new record into table with auto-increment on primary key
  26. Select mySQL based only on month and year
  27. Mysql InnoDB engine in Laravel
  28. MySQL: Group by two columns and sum
  29. Which MySQL datatype to use for an IP address? [duplicate]
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment