286
edits
Changes
Jump to navigation
Jump to search
no edit summary
<b>MYSQL Commands for the MYSQL CONSOLE:</b>
(try to use mysql console instead of phpmyadmin)
If you want to show the size of all databases installed do:
login as mysql admin
<pre>
mysql -u admin -p
</pre>
at the mysql prompt do:
<pre>
mysql> SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;
</pre>
Create database named "test":
<pre>
mysql> create database test;
</pre>
Delete database named "test":
<pre>
mysql> drop database test;
</pre>
Update/Reload Databases at MYSQL Server:
<pre>
mysql> flush privileges;
</pre>
Dump all Databases - Note: This do only if you want Restore the same Server, cause MySQL System Databases like "mysql or information_schema" are dumped too!! This will break on other Servers!
<pre>
mysqldump -u root -p --opt --all-databases > databases-dump-$date.sql
</pre>
Better do write a Bash Script to dump every Database for its own! This does not scramble a fresh setup!
(try to use mysql console instead of phpmyadmin)
If you want to show the size of all databases installed do:
login as mysql admin
<pre>
mysql -u admin -p
</pre>
at the mysql prompt do:
<pre>
mysql> SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;
</pre>
Create database named "test":
<pre>
mysql> create database test;
</pre>
Delete database named "test":
<pre>
mysql> drop database test;
</pre>
Update/Reload Databases at MYSQL Server:
<pre>
mysql> flush privileges;
</pre>
Dump all Databases - Note: This do only if you want Restore the same Server, cause MySQL System Databases like "mysql or information_schema" are dumped too!! This will break on other Servers!
<pre>
mysqldump -u root -p --opt --all-databases > databases-dump-$date.sql
</pre>
Better do write a Bash Script to dump every Database for its own! This does not scramble a fresh setup!