Some MySQL Admin Stuff

make sure it’s running
ps -ef | grep mysql

Creating MySQL DB

HOWTO on creating MySQL DBs
 
mysql -u root -p
# Enter your root password

Now, inside MySQL shell
mysql>create database cafecenter;

Query OK, 1 row affected (0.00 sec)
mysql>show databases;


+----------+
| Database |
+----------+
| database |
| mysql |
| cafecenter|
| test |
+----------+

4 rows in set (0.01 sec)

mysql>

Create a username/password that has at least the following privileges for the database: SELECT, INSERT, UPDATE, DELETE"

mysql> use mysql

mysql> GRANT ALL ON database_name TO manager@localhost IDENTIFIED BY "Contract$$$";

Query OK, 0 rows affected (0.00 sec)

mysql> quit

To work with a single database:
mysql> use DATABASENAME;
mysql> show tables;
mysql> select * from TABLENAME;
 
————————————-
 
Import a dump file into database after uploaded it onto the server
 
mysql -p -h localhost cafecenter < /var/www/html/install/rayzz_new.sql
 
————————————-
Useful Commands:
 
$ mysqldump db_name my_table

$ mysqldump db_name my_table > output.sql

$ mysqldump --no-data db_name my_table > dump_table_name.sql

$ mysqldump --add-drop-table db_name my_table > dump_table_name.sql

$ mysqladmin create db_name

$ mysqladmin drop db_name

$ mysqladmin flush-privileges

$ mysqladmin ping

$ mysqladmin reload

$ mysqladmin kill ps_id,ps_id...

$ mysqladmin --user=root shutdown

$ mysqladmin variables

$ mysqlimport db_name file_name ...

$ safe_mysqld

$ myisamchk table_name.MYI

Leave a Reply

Your email address will not be published. Required fields are marked *