Retrieving info from 2 tbls & ordering it

2009-09-23 Thread Warren Windvogel
Hi I have 2tables. 1 for incoming & the other for outgoing messages. They both have columns for the userid & datetime_received/sent. I'd like to retrieve all records from both tables for a specific user id & order all the records returned by the two datetime_received/sent fields. Is this poss

Re: Restore information

2008-07-21 Thread Warren Windvogel
Olaf Stein wrote: Is my assumption correct that you dump your main production db and restore it to a second server? And this restore is what you want to verify? That is correct. Warren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

Restore information

2008-07-21 Thread Warren Windvogel
Hi All, Is there a simple way of checking when the backup db server performed its last restore and whether it was successful or not. I need to ensure that the dump and restore of the production box has run successfully every night until proper backup/DRP procedures are in place. I'm not famili

Re: Count total number of records in db

2008-07-11 Thread Warren Windvogel
Radoulov, Dimitre wrote: mysql -NBe'show databases' | while IFS= read -r db; do printf "show tables from %s;\n" "$db" | mysql -N | while IFS= read -r t; do printf "select count(1) from %s.%s;\n" "$db" "$t" done done | mysql -N | awk '{ s += $1 }END{ print s }' I quickly

Count total number of records in db

2008-07-11 Thread Warren Windvogel
Hi, Can anyone tell me how to check the total number of records in a database in MySQL version 4.0 Googling doesn't seem to help and all previous posts assume version 5.* Regards Warren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Forcing import

2008-07-10 Thread Warren Windvogel
Hi, Is there a way to force mysql to import a dump which contains a mysql reserved word as a field name? Regards Warren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]