Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Using Shell> or restoring database using mysqlbinlog
Posted by: nb1204 (---.hsd1.ga.comcast.net)
Date: April 28, 2011 10:48PM

I've been at this all day. Accidentally dropped database tables. Need to restore. I do see what I need and the tables in the bin log. I see the commant to run the restore at the shell> promt but don't know hot to get there. When I run the command from mysql> it does nothing but go to another line. Does anyone either know how to get to the shell> or to tun the mysqlbinlog file to restore.

Options: Reply•Quote
Re: Using Shell> or restoring database using mysqlbinlog
Posted by: stevenmartin99 (---.251.255.13.threembb.ie)
Date: April 28, 2011 10:57PM

Use ; To terminate commands

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: Using Shell> or restoring database using mysqlbinlog
Posted by: nb1204 (---.hsd1.ga.comcast.net)
Date: April 29, 2011 02:27AM

What I'm trying to run is this:

shell> mysqlbinlog --stop-datetime="2011-04-28 09:20:20" mysql-bin.000016

To restore database to that time and date. But my command like starts with

mysql>

Options: Reply•Quote
Re: Using Shell> or restoring database using mysqlbinlog
Posted by: stevenmartin99 (---.21-151.libero.it)
Date: April 29, 2011 08:47AM

Put ; at the end

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login