Tag Info

New answers tagged

0

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.


0

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 ...


0

mysqldump --no-data big_db_name > big_db_name.structure.sql


0

Dump table structure only wth the below codes mysqldump -d -h localhost -uYourUsername -pYourPassword databasename > dumpfile.sql


2

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 ...


0

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