* Nixarlidis Aris > Hi to all. > I'm new in the list and in mysql as well, so excuse me for anything that > sounds novice or in wrong place.I'm facing the following situation: > > For some reason, i had to use a backup of the database.Because of the > difference in time between my backup and the instance i had to use it,i > want to retrieve from the database, I no longer use, some records BUT NOT > ALL the database.Is there a way to do it?
Of course. A database would be pretty useless if you could not retrieve partial information from it. :) Your database contains tables, and these tables may be SELECTED from. You can also INSERT information into a table based on what you have SELECTed from another table: <URL: http://www.mysql.com/doc/I/N/INSERT_SELECT.html > So, what you need is probably something like this: INSERT INTO newdatabase.table1 SELECT * from olddatabase.table1 WHERE ... This must be repeated for all your tables. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
