New answers tagged export
You can specify the OUTPUT to a file in your SQL directly: dbisql -c "connection-string" SELECT * FROM table; OUTPUT TO 'results.txt' FORMAT TEXT As per the Sybase documentation.
Since you specifically asked about phpMyAdmin and the previous answers, while correct, are both about doing this on the command line: Navigate to the database you wish to export. Across the top row of tabs click "Export" Next, click the Custom radio button Halfway down the "Format-specific options" area, select "structure" (the default is "structure ...
mysqldump --no-data big_db_name > big_db_name.structure.sql
Dump table structure only wth the below codes mysqldump -d -h localhost -uYourUsername -pYourPassword databasename > dumpfile.sql
since the database size is large you should make the dump command like the following: mysqldump -u USER -p --single-transaction --quick --lock-tables=false --all-databases (or) DATABASE | gzip > OUTPUT.gz --quick:This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than ...
You should modify the mysqldump command and use --single-transaction. All new changes to the database are stored in a transaction and you have valid point-in-time-database backup. I have two steps: I export the database as a dump and the next step is to zip the dump, but i never tested if this make any differences. You could use other backup software like ...
Top 50 recent answers are included