The command line option from SSH is: mysql -d -p database_name > file.sql. Where 'database_name' is the name of your database, and 'file.sql' is the name of the file you would like to write the table structure to.& ;You& ;will be prompted you for a password (-p). Normally mysqldump gives you the entire database, with the '-d' option, you& ;need to tell it to not include the data, just the table structure.
- 2 کاربر این را مفید یافتند
مقالات مربوطه
Do I use localhost or remotemysqlhost for my mysql connection?
You can view whether your account is using localhost or remotemysql host in your cPanel account....
How can I connect to a MySQL database from Dreamweaver?
To connect to a MySQL database from Dreamweaver follow the below steps:Login to your cPanel...
How do I create a MySQL backup?
There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel...
How do I create a MySQL database?
To create a MySQL database please follow the steps below:- Login to your control panel at...
How do I import a MySQL database?
To import a database follow the below steps:I have a backup of my database that I need to...
