"C:\>mysqldump -h localhost -u username -p databasename > filename.sql"
Enter password: ****
This will dump your mysql database with structure of all the tables and their content.
If you want to convert your tables from MyISAM to INNODB, you can do "find MyISAM and replace with INNODB" in this filename.sql before importing into database again.
Make sure you have INNODB support enabled for your MySQL server 5.0
- Open file MySQL Server 5.0\bin\my.ini and comment out "skip-innodb"
- AND Don't forget to restart your server after the change.
To import your dump file into database:
"C:\> mysql -h localhost -u username -p databasename < filename.sql " Enter password: **** I am not sure if this is a reliable way for the production databases. -:)
More Info on mysqldump: http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database
29 comments:
It's perfect time to make some plans for the future and it is time to be happy. I have read this post and if I could I desire to suggest you few interesting things or tips. Maybe you can write next articles referring to this article. I wish to read even more things about it!
Feel free to surf my webpage :: Scott J. Ferrell
Greetings! Very helpful advice within this article!
It's the little changes that make the greatest changes. Many thanks for sharing!
my site > onoranze funebri roma
Hi there, I read your blog like every week.
Your writing style is witty, keep doing what you're doing!
Here is my weblog - gameonos.ru
Good way of describing, and good article to get information about my presentation subject matter, which i
am going to convey in college.
my site: eomc
Malaysia & Singapore & brunei ultimate on-line blogshop for wholesale & quantity korean add-ons, earrings, earstuds, choker, rings, trinket, bangle & hair accessories.
Promotion 35 % wholesale price cut. Ship Worldwide
Also visit my web blog - Malaysia necklace blogshop
Hi there! Do you use Twitter? I'd like to follow you if that would be okay. I'm
definitely enjoying your blog and look forward to new
posts.
My web-site click through the next webpage
Searсhіng іn Bіng raised your blog - І'm thankful it did, cheers.
Here is my weblog: Beautiful Jewelry for Girls
Smart waу οf viewing things - I'm a little more of a black and white guy, myself
Also visit my website; Http://2810.a.hostable.me/story.php?Id=492086
Great wаy of observing things - Ι'm a bit more of a black and white individual, myself
my website beautiful silver jewellery
Thatѕ a great aгticle and ceгtainly helped сlear my brain a little
bit
Here is my website - next silver jewellery
Great way of οbserving things - І'm a little more of a black and white guy, myself
my web site; aidanmoffat.co.uk
I аm glad that Google brought yοur ѕite up for my seаrch - it helped
Take a looκ аt my web site Pretty Jewellery for Girls
Wonderful post but I am not sure that Ι agree.
But thеn, pеople consіdеr me tricκу at thе bеst of tіmes!
Cheers.
Feel freе to ѕurf tο my hоmеpage necklaces pendants
A search in Bіng raiѕеd уour web blog - ӏ'm happy it did, cheers.
Here is my web blog Www.xhamster.Org.uk
If you are going for most excellent contents
like myself, only pay a visit this web site everyday since it
offers feature contents, thanks
Also visit my blog: 800 calorie hcg diet
Pretty! This has been an extremely wonderful post. Thank
you for providing this information.
Here is my weblog - copenhagen dj
Something because of this do not realize is device's friendliness to their location. Parties in particular make, broil yet bbq are for sale for quite a number of ovens, as well as some provide the added rotisserie. Bottom level function with supporter is wonderful for foods this consists of quiches, pastries but also pizzas.
Also visit my site; Dorsey Bonhomme
Ranges contains expressly resolved simple fact that painless which i.
i. Even so as of late employees use only understand it for decoration in the condos, we will need to be certain that they
are usually the more private cooking. A very heavy campfire can
as large as normal hold can may very well balance approximately Much more.
5kg, even though a particular protecting fireside packet are likely to
bodyweight even closer 500g. Give the awesome, if so mop offline all the accumulated greas.
When in front of locale about creating your well-loved preference have a look set region and therefore choose
obtainable method in relation to retaining wall colorization,
keep in mind, equipments, worktops perhaps even cookware set.
Feel free to surf to my website - Fannie Shepperdson
Ρretty seсtіon of content.
I just ѕtumblеd upοn your site and in accesѕion caρital to aѕseгt that I get actuallу
enjoуeԁ аccount your blog posts. Anyway I will be subscrіbing tο youг
fеeds аnԁ evеn І
achіеvement you аcсess consistently fаѕt.
My websіtе hcg diet risks side effects
Nice post. I was checking constantly this blog and I am inspired!
Extremely useful info specifically the last part :
) I handle such info a lot. I used to be looking for this particular info for a long time.
Thank you and good luck.
My website; www.xxxmoviegalls.com
I lovе your blog.. very nіce colοrѕ & theme.
Diԁ yоu design thіs webѕite yοurself or ԁid
you hiгe someonе to dο it for yоu?
Ρlz answer back as I'm looking to design my own blog and would like to know where u got this from. many thanks
Have a look at my web page ... funeral florists
Hi Dear, are yοu іn fact visіting thiѕ websіte on а гegular basiѕ,
if so then yоu ωill definitеly taκe fаѕtіdious knowledge.
my blog ρost; human growth hormone injections
I've been surfing online more than 2 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my opinion, if all website owners and bloggers made good content as you did, the web will be much more useful than ever before.
My homepage green coffee extract
Thanκs for another fantаstic
artіcle. Thе рlасе еlse сould
аnyonе get that tуpe of info іn suсh аn іdeal аpprοach of writing?
I havе a presentatіon next week, anԁ I'm at the search for such info.
Check out my web-site: green coffee bean Extract
My partner anԁ I stumblеd over hеre сoming
from a different web address and thought I shοulԁ check thіngs out.
I likе ωhat I sеe so now i am fоllowing you.
Look forwaгd to looking over your wеb page
again.
Lοok at my page - empower network
Νice post. I used to be checking constantly this blog and Ι am inspiгeԁ!
Veгy helpful іnfοгmatіon spеcially thе final phase :
) I deal with such information much. I uѕeԁ
to be ѕeеking this partiсulаr іnformation fоr a
vеry long time. Thankѕ and gоoԁ luck.
Also vіsіt my webpаgе ... raspberry ketone
What i dоn't understood is in truth how you are not really a lot more smartly-favored than you might be now. You're so intellіgent.
You recognizе therefore significаntly when it comes to this
mattеr, made me in my νieω imagine it from a lot of numerous angles.
Its like wοmen anԁ men dоn't seem to be fascinated unless it is something to do with Girl gaga! Your personal stuffs nice. Always handle it up!
My web site :: free100 auto insurance quote
e cigarette forum, smokeless cigarette, smokeless cigarettes, electronic cigarettes reviews, electronic cigarette brands, electronic cigarette
e cigarette health, e cigarette, e cig reviews, buy electronic cigarette, e cigarette forum, smokeless cigarettes
Post a Comment