JBANK
The code above will generate a procedure called get_table(SEARCH_STRING) , that will accept 1 parameter which is your string. It will search through the whole database server besides these db(information_schema,test,mysql). But if you would...
https://www.linode.com/docs/email/postfix/email-with-postfix-dovecot-and-mysql/#dovecot
Firstly, We have to create a new user from different ip , so we have to run the below command. The first “Select” query is to get all column in user table and the...
Procedure Creation Example MariaDB [stress]> DELIMITER ;; MariaDB [stress]> CREATE PROCEDURE ABC() -> BEGIN -> WHILE 1 -> DO -> SELECT COUNT(*) FROM stresstable; -> DO SLEEP(1); -> END WHILE; -> END;; MariaDB [stress]>...
# dumping data without lock table mysqldump -u[USER] -p[PASS] –skip-lock-tables –single-transaction –flush-logs –hex-blob –master-data=2 –max_allowed_packet=1G globe_sdp > globe_sdp_v2.sql
Hi, i’ve recently created a pmm-server ( monitoring system for server & mysql ). A pmm-server act as a server and client can connect to pmm-server to look on their information by using the...
#EXPORT mysqldump -u {USER} -h {IP} -p {DB_NAME} {DB_TABLE (OPTIONAL)} | gzip > dump.sql.gz #IMPORT CREATE DATABASE {DB_NAME} mysql -u {USER} -h {IP} -p {DB_NAME} < dump.sql option:- -d : to dump only table...
UPDATE game SET g_game_path = REPLACE(g_game_path,”s1.g”,”um”); For the query above, is to update the “game” table , to replace g_game_path’s “s1.g” into “um”
To select data from table a to insert into b INSERT INTO ‘DB_NAME’.’TABLE_NAME'(TABLE_FIELD) SELECT ‘FIELDS_TO_INSERT_MUST_BE_TELE_WITH_INSERT_FIELD’ FROM ‘DB_NAME’.’TABLE_NAME’ WHERE (CONDITION);
1.Stop mysql service 2.then run this command mysqld_safe –skip-grant-tables & 3.mysql -u root 4.Run Below Command:- use mysql; update user set password=PASSWORD(“mynewpassword”) where User=’root’; flush privileges; quit 5.stop start mysql service and you’re good...
