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
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
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
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
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
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]