MySQL Truncating or Dropping All Tables in a Database

I just had the need to truncate all the tables in of my databases. Basically I wanted the data gone but the schema to stay. Below is the linux shell command I used to truncate the tables.

I’ve also included how to straight up drop the tables too- just keep in mind dropping tables dumps the schema and data.


mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "truncate table $table" DATABASE_NAME; done


mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "drop table $table" DATABASE_NAME; done

Make sure the user executing this has privileges to the database in question.

Jeff’s Raspberry Pi Setup Notes

Raspberry Pi Setup Notes

These are the notes I keep for initial setups of the base Raspberry Pi Linux images.  They were collected from all over the internet and from personal experiences. If you find errors let me know. I’m always updating it so check back if you’re looking to add a feature that you can’t find
anywhere else.

Everything here relies on what exists on the internet already. Nothing here is original except that it’s all in one place.

LAMP Setup

sudo apt-get install apache2


sudo apt-get install nginx


sudo apt-get install mysql-server

sudo apt-get install php5 php5-mysql

Further  LAMP features

sudo apt-get install php5-fpm php5-cgi php5-cli php5-curl php5-gd php5-idn php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-mhash php5-pspell php5-recode php5-sqlite php5-tidy php5-xmlrpc php5-xsl php5-xcache

More Stuff

sudo apt-get install chkconfig snmp net-snmp* imagemagick htop webalizer


sudo pear channel-update sudo pear install MDB2

sudo pear install pear/MDB2_Driver_mysql


To install Webmin open a terminal and add the following repository:

1- Edit /etc/apt/sources.list file

sudo nano /etc/apt/sources.list

2- Add the following lines

deb sarge contrib

deb sarge contrib

Save and exit the file

3- Now you need to import GPG key


sudo apt-key add jcameron-key.asc

4- Update the source list

sudo apt-get update

5- Now install Webmin

sudo apt-get install webmin

Now to access Webmin open your browser and enter:  http://serverip:10000/

You can get your ip address by issuing this command:



Remove any unneeded packages

There will eventually be packages that are unneeded. Apt-get can get rid of them by issuing this command:


sudo apt-get autoremove

Remote Desktop

Installing this allows you to connect via RDP on Windows.

sudo apt-get install xrdp

Add Chrome/Chromium to Desktop

Adds “Chrome” web browser to the GUI interface.

sudo apt-get install chromium-browser

Check CPU Clock Speed

This will show the current CPU clock speed in hertz

 cat /sys/devices/system/cpu/cpu0/cpufreq/scaling_cur_freq


This is the initial configuration utility. I always forget its name..

sudo raspi-config