You should know your purpose in life, make a difference, and believe in yourself. Always think positive, take the risk and move forward. Do that, then before you know it, you're already the man you always wanted. Cheers!!
▼
Wednesday, December 22, 2010
How to drop all tables in MYSQL via console
On your console, just type the script below supplying the root access credentials [HOST], [USERNAME], [PASSWORD], and [DATABASE] to access the server.
mysqldump -h [HOST] -u [USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -h [HOST] -u [USERNAME] -p[PASSWORD] [DATABASE]
No comments:
Post a Comment