antisaWiki

User Tools

Site Tools

Trace:
wiki:mysql_miscellaneous_commands

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
wiki:mysql_miscellaneous_commands [2022/10/15 09:57] – add Password change, Select only certain tables from DB, Backup database directly on another server antisawiki:mysql_miscellaneous_commands [2022/11/12 11:30] (current) – [Password change] add mysqladmin command antisa
Line 44: Line 44:
   FLUSH PRIVILEGES;   FLUSH PRIVILEGES;
  
 +Or
 +
 +  mysqladmin -u root -p'OLDPASSWORD' password NEWPASSWORD
 ===== Select only certain tables from DB ===== ===== 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   mysql -p -N information_schema -e "select table_name from tables where table_schema = 'dbname' and table_name like 'wp_3_%'" > tables.txt
wiki/mysql_miscellaneous_commands.1665827858.txt.gz · Last modified: 2022/10/15 09:57 by antisa
Except where otherwise noted, content on this wiki is licensed under the following license: CC0 1.0 Universal
CC0 1.0 Universal Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki