mysqldump -d -u username -p dbname > dbname_tables.sql
mysqldump -d -u username -p dbname > dbname_tables.sql
GRANT ALL PRIVILEGES ON db_name.* to 'new_user'@'hostname' IDENTIFIED BY 'password';
show full processlist;
mysql -h hostname.com -u user -p dbname --execute="select DISTINCT(column_name) from tablename" > file.txt
Get current timezone:
SELECT @@global.time_zone;
Set new timezone:
SET GLOBAL time_zone = 'Europe/Helsinki';
Recent Comments