Tag Info

New answers tagged


It isn't possible as SQL Server Native Client is a client library for SQL Server, not for MySQL. If you want to access a MySQL server through ODBC, then you need the MySQL ODBC driver (Connector/ODBC).


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

Top 50 recent answers are included