Re: selecting the last 10 rows

2006-12-30 Thread Panos Tsapralis
archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Panos Tsapralis, Senior Software / Systems Engineer, +306948076902, Athens, GREECE.

Re: howto query DELETE all records having invalid table refs

2006-12-20 Thread Panos Tsapralis
been wiped out of GbEntries table. DELETE GbEntries Accounts WHERE Sender NOT IN Accounts.ID; but how's the proper SQL syntax for this? Thanks in advance, Christian Parpart. -- Panos Tsapralis, Senior Software / Systems Engineer, +306948076902, Athens, GREECE.

Re: Undelete a droped table

2006-11-08 Thread Panos Tsapralis
it the database name and the file names. It's a way to put back a backup made of the physical database if you backup directly from the SQL data directory and not through the SQL backup utility and then through your tape or other backup. Scott. -- *From*: Panos Tsapralis [EMAIL

Re: Undelete a droped table

2006-11-07 Thread Panos Tsapralis
) instead of permanently deleting them? In that case, it would be possible to recover a dropped table by creating a blank table into the database (equivalent to the one that got dropped) and then replace its empty data files with those from the Recycle Bin. HTH, Panos Tsapralis. On 11/7/06, Eric

Re: Transfering Databases

2006-11-05 Thread Panos Tsapralis
Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Panos Tsapralis, Senior Software / Systems Engineer, +306948076902, Athens, GREECE.