mysql | Bash Script

Tag Archives: mysql

Empty a database table command

October 23, 2013bashcommand, empty, mysqladmin

How to empty a mysql database. Forget about delete * command

 bash | 
 
 copy code |
?

1 #!/bin/bash mysql -D $DATABASE -e 'TRUNCATE TABLENAME;'

Get MySQL options with my_print_defaults

October 23, 2013bashmy_print_defaults, mysqladmin

my_print_defaults displays the options that are present in option groups of option files

 bash | 
 
 copy code |
?

1 my_print_defaults mysqld 
2

MySQL Server Status in plesk

October 23, 2013bashmysql, plesk, statusadmin

Get information about your mysql server. Uptime, threads, slow queries,…

 bash | 
 
 copy code |
?

1 mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` status
2 Uptime: 16203737  Threads: 1  Questions: 101442770  Slow queries: 1359  Opens: 3857138  Flush tables: 1  Open tables: 64  Queries per second avg: 6.260
3

How to rename a mysql database or table

October 16, 2013bashdatabase, mysql, rename, scriptadmin

Here is a dirty script to rename a mysql database or table from command line. Dont for get to stop mysql service!

 bash | 
 
 copy code |
?

01 cd /var/lib/mysql/
02 /etc/init.d/mysql stop
03 # rename database...
04 mv olddbname newdbname
05 # ...or table
06 cd database/
07 mv oldname.frm newname.frm
08 mv oldname.MYD newname.MYD
09 mv oldname.MYI newname.MYI
10 /etc/init.d/mysql start

1	mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` status
2	Uptime: 16203737 Threads: 1 Questions: 101442770 Slow queries: 1359 Opens: 3857138 Flush tables: 1 Open tables: 64 Queries per second avg: 6.260
3

01	cd /var/lib/mysql/
02	/etc/init.d/mysql stop
03	# rename database...
04	mv olddbname newdbname
05	# ...or table
06	cd database/
07	mv oldname.frm newname.frm
08	mv oldname.MYD newname.MYD
09	mv oldname.MYI newname.MYI
10	/etc/init.d/mysql start