The single command approach mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname make sure you can … mysql -h newhost -u newusername -pnewpassword newdbname … before attempting the transfer. Common issues are :- Firewall preventing access to MySQL server across the network User configured to only be able… Read More »
[mysqld] … log-output=TABLE expire_logs_days=1 general_log=1 general_log_file=/var/log/mysqld-queries.log slow_query_log=1 slow_query_log_file=/var/log/mysqld-slow-queries.log … Selec All Code:1
Selec All Code:1 Should give you the number of rows and the size the tables in your database are using currently.
http://interconnectit.com/products/search-and-replace-for-wordpress-databases/ Download : searchreplacedb21
Syntax DatePart(interval, date [, firstdayofweek] [, firstweekofyear] ) The DatePart function syntax has these arguments: Argument Description interval Required. String expression that is the interval of time you want to return. date Required. Variant (Date) value that you want to evaluate. firstdayofweek Optional. A constant that specifies the first day of the week. If not… Read More »