To remove only the tables in DB :


Go to terminal and excute the bellow command with your database username ,databasename , and password :

mysqldump -u username -p --no-data dbname | grep ^DROP > drop.sql 

mysql -u username -p dbname < drop.sql   

rm drop.txt

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Start and Stop ssh-agent

Below is the bash script used to start and stop ss-agent #!/bin/bash ## in .bash_profile SSHAGENT=`which ssh-agent` SSHAGENTARGS="...

  • How to Upgrade OpenSSL on UBUNTU
    How to Upgrade OpenSSL on Ubuntu This quick tutorial outlines how to upgrade openssl to the latest version on Ubuntu Server 13.04. A m...
  • Start and Stop ssh-agent
    Below is the bash script used to start and stop ss-agent #!/bin/bash ## in .bash_profile SSHAGENT=`which ssh-agent` SSHAGENTARGS="...