#mysql - Thu 26 Apr 2007 between 00:55 and 01:09

NY Lost Funds



nils_when do you mysqldump?
cosand that is the file I'm starting with
nils_yeah well not the first but the last log created
cos"when do you mysqldump" doesn't apply, there is no schedule, this is my test setup and I'm just trying the first dry run.
I ran mysqldump earlier today.
nils_yeah
actionToeBee is running mysqldump right now
ToeBeeis running mysqldump right now
nils_the mysqldump shall flush logs, and the last binlog is the one containing queries that are not in your dump
cosI ran it, looked at the logs to make sure it flushed them at the time it ran, then did some stuff that caused data to be written
then I dropped the database, recreated it, and restored the dump. that went fine.
chadmaynardon gentoo?
nils_well that's what you have to do..
cosnow I want to restore from that one binary log that spans the period between the dump and the restore
nils_and there are duplicate key errors
cosbut that is the one that gives me those errors
nils_strange stuff
so the dump has data that already ended up in the binlog
cosit *seems* to be similar to the problems other people have reported with restoring tables with auto_increment columns, but I'm not sure, because it's not the same thing.
so that may be a coincidence
but the binlog is actually fairly short, so I can look at all of it, and it all looks like data that I caused to be updated after the mysqldump
anothernamenils_: Here is a picture of what phpMyAdmin EXPORT page. http://i3.photobucket.com/albums/y88/toastedass/phpMyAdmin.jpg
liquidengineerDoes anyone use Navicat?
anothernameoh what it looks like**
nils_anothername: when you press go does it give you a file to import rightaway?
cosnils: so you agree I am doing the right thing and this is strange, at least :)
anothernamenils_ all settings like you see... when I press go... it gives me a dump.
nils_yeah well you can import it from phpmyadmin
cos: yeah that's standard procedure in smaller setups
so guys, time to leave, it's about 5 AM here and I have to get some sleep
anothernamealright nils_ thanks for all the help... I'll figure this damn thing out. :)
nils_good luck
anothernamegoodnight.
thank you.
nils_good fight, good night ;)
linagee_what happens if i delete all the users? delete from user; delete from db; ? :(
how can i re-add a root user
chadmaynardwhy not just mysql_install_db to re-add it?
linagee_hmm
chadmaynard: what does that do?
should i just drop the mysql database then do that?

Page: 2 9 16 23 30 37 44 51 58 

IrcArchive

NY Lost Funds