Differences

This shows you the differences between two versions of the page.

--- wiki:mysql_miscellaneous_commands [2021/04/29 16:47] – created antisa
+++ wiki:mysql_miscellaneous_commands [2022/11/12 12:30] (current) – [Password change] add mysqladmin command antisa
@@ Line 38: / Line 38: @@
 WHERE C.COLLATION_NAME IS NOT NULL AND C.TABLE_SCHEMA='db' AND T.TABLE_TYPE='BASE TABLE';
 </code>
+===== Password change =====
+  USE mysql;
+  UPDATE user SET password=PASSWORD("pwd01") WHERE user='root';
+  FLUSH PRIVILEGES;
+Or
+  mysqladmin -u root -p'OLDPASSWORD' password NEWPASSWORD
+===== Select only certain tables from DB =====
+  mysql -p -N information_schema -e "select table_name from tables where table_schema = 'dbname' and table_name like 'wp_3_%'" > tables.txt
+===== Backup database directly on another server =====
+  mysqldump –extended-insert=FALSE -uroot -pmypwd dbname tablename | pbzip2 -p4 -m1000 -c | ssh root@example.com 'cat > /backup/dbname_backup.sql.bz2'
 ====== Tested on ======
   *