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

  • PPTP VPN Server on Debian/Ubuntu
    PPTP VPN Server on Debian/Ubuntu Quick setup: Copy and Paste This section is for the impatient. All you have to do is login to your De...
  • 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="...