You should log in:
  Forgot password?
Don't have a username? That's okay, Register now. It's really easy.

Ryan's lists:

• $livelaugh puzzle playlist
• 2011/2012 Playlist
• 30 day projects
• Ads I like
• Adventures in design
• Adventures in Nerdery
• ah yes, Tempe
• April Foolery 2011
• Articles that I like
• as soon as I get off of work
• Assholes
• Autocad commands
• Awwwwww yeaaahhhhhh
• Badasses
• Beers I like
• Before I die
• Bicycle Saturday
• Billionaires with Facial Hair
• Blog
• Blog posts you should read
• Bookmarks
• Books I really really urgently need to read.
• Books to read
• breaking news
• Burning Man First Aid Kit
• Burning man packing list
• Burning Man Pictures
• Burning man road trip playlist
• Challenge a day
• Check ins
• color run photos
• Comics I love
• Cool ancient stuff
• Dear Alien Overlords
• Documentaries
• Dogfood
• Drawings and such
• Dream Garage
• Drinks I like
• Electro House
• electronics parts suppliers
• everything went better than expected
• Existence!
• Feels good, man
• Future Projects
• Gifs that should always be in the hopper
• Gifts for Geeks
• Gives me hope for the future of humanity
• Good bars in Phoenix
• Good food in Phoenix
• Great songs for coding
• Hacker Fuel
• Hacker Lore
• Happy things
• hashtag lifehacks
• Heatsync Music
• Heros of mine
• How I know it's a bubble
• How I know it's the future already
• How things should be
• How to identify a hipster
• How to identify freshmen on a college campus
• Human bug tracker
• Humor
• I have amazing friends
• I love you, google
• Iced Dev Subsidiaries
• If Only
• Inspiration things
• Jay-Z lines
• lanmarks
• lectures
• lectures and talks I like
• Life lessons I wish I wasn't learning
• List of demands
• lol
• Magazines
• Make Log
• man, WHYYY!?!?
• Mashups I like
• me circa 2004 according to gmail
• Memetic Sillines
• Mix CD
• Montage Music
• Movies
• Movies I like
• Movies to watch with $alyson
• Music
• Music for $cody
• Music Sunday
• N64 Games to play
• Nostalgia
• OmNomNomNom
• Operation New Bicycle
• Parts I want
• People have too much money
• People I hope to meet someday
• People I like
• People who accidentally posted to Ryan's list.
• people you should check out
• Phoenix Repeaters I like
• Photo Of The Day
• Photo Things
• Photography Things
• Picnic Music Exchange
• Pictures of the dog
• places I want to visit
• Places that need faster wifi
• Places to go with $livelaugh this summer
• Please cure my sickness
• Programing Things
• Programming Milestones
• Proof that I actually leave the computer sometimes
• Quotes
• Rainy Day Music
• Reasons I love Google
• Reasons that $cody should go to burning man
• Reasons to move to Portland
• Reasons to move to San Francisco
• Recipes
• Relaxing Music
• Saguaro Man
• Second Saturday Sad Songs
• Someday
• Songs I like
• sounds a lot easier than it is
• Status
• Stuff for Dallas Office
• Stuff for saguaro man
• Stuff I'm working on
• Summer Songs
• Tech News
• thingist features
• Thingist todo list
• Things $alyson and Joe Rogan agree on
• Things $alyson says
• Things about bicycles
• Things for burning man
• Things for geeks
• Things for makers
• Things google+ got right
• Things google+ got wrong
• Things hipsters love
• Things I can't wait for
• Things I dislike about my house
• Things I hate
• Things I learned today
• Things I like
• Things I love
• Things I read
• things I really did not think I would still be using in 2010
• Things I want for Christmas
• Things I want to play in.
• Things I want to teach $natalie
• Things I was wrong about
• Things I will do more of during unemployment
• Things I would recommend
• Things in my dream house
• Things Mitt Romney actually believes
• Things my crazy neighbor says
• Things my insane neighbor says
• Things on my bookshelf
• Things on the menu at a nerd-themed restaurant
• Things redditors like
• Things that $Natalie should teach me
• Things that Amy is amazingly good at
• Things that are real in my head, damnit!
• Things that can dance better than me
• Things that fly
• Things that give me hope for the future of humanity
• Things that made my day
• Things that make me fear for the future of humanity
• Things That Make Me Feel Better When I'm Sad
• Things that make me sad :(
• Things that might kill me
• Things that scare me
• Things that startupgrrl should do.
• Things to help you learn python
• Things Travis Says
• Things you should find in every IT department
• things you should read
• Things you should watch
• Thinngs I use my pocketknife for
• This is why
• times when cold weather is good
• Today in Hackery
• TV Shows I like
• US News
• useful windows things
• Wapred tour 2011 photos
• Warped Tour 2011 Photos
• we are doomed
• We basically live in Star Trek
• We're trying to have a society over here
• What is this demonry?
• What to do when life gives you lemons
• Why we can't have nice things
• Wine
• Words that are sexy
• Wub Wubs and Yip Yips
• Yes, I'm bragging
• you chose...poorly
• You dun goofed
• you're doing it right
• you're doing it wrong.
• You's trollin'
• Your move, government.
How to manually back up and restore a mysql database
Added to: Things I learned today
This seems...obvious, and I don't know why it isn't more obviously googlable.

There is a directory:

/var/lib/mysql/$db_name/ and in that directory are some files that correspond to the relevant tables in the DB.

Just...copy the files into a new directory on a new machine, and the new machine will see your "new" database.

---------------

STORY TIME!

Our old "prod" server[1] needs to be rebuilt. Now I know why people don't run gentoo in production, haha. There are some core packages that emerge flat out refuses to install right now. I'm sure I could force some things through, but honestly, I'd rather just go for a re-install.

Well, one of the packages that won't re-merge is mysql, which is what I use for DB. The daemon fell off, and when I try to restart it, it flames out (and no useful output no matter HOW many "-v"s I append to mysql_safe.)

Sucks.

I mostly stopped caring about this machine about a year ago (hey, right around the time thingist started!), and the backups were anything but fresh.

Well...shit.

No matter, the old database is happily on thingist's server now, and I got what I needed out of it!

[1]: "Prod" used to be the machine I used for an old project, newslily, which was the first thing that $cody and I built together (and is currently in the process of being rebuilt). Thingist started out on "dev", because it started out as what was supposed to be a tiny, tiny side project.

"Dev" became "prod", and this is now where all of my projects live.
| Share This

 
Log in or register to use comments