Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

simple mysql questoion

 
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How do I create a new database from a dump?(I have a .sql dump I need to put on my machine)
Not too sure of the best command to do this using mySQL3.2
Thanks in advance
 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, Eric,
to get the solution for your problem do the following steps:
  • go to the MySQL Homepage (www.mysql.com)
  • you will find a search field to the left. Enter 'dump' in it
  • you will get a result of your search
  • click on the first link of the result
  • locate the line "You can read this back into MySQL with..."


  • The MySQL Manual is a great source of information for problems of this kind. You will get it much quicker and more detailled, if you search there first, before you post here.
    good luck
    Hartmut
     
    Eric Howell
    Ranch Hand
    Posts: 63
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Thanks Hartmut
    Still having problems.
    I can't figure out where I have to put the dump. Do I place it in the bin directory ?
    I tried a few of the commands and couldn't seem to progress. At the sql prompt what command should I use ?
    The batch file is called backup.sql
    Thanks for your help in advance
     
    Eric Howell
    Ranch Hand
    Posts: 63
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Thanks Hartmut
    Am now sorted. I used SOURCE command in the mySQL client and it worked.
    Found this out from a FAQ site:
    http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_7_0
    Check it out
    Thanks again for the help
    Eric
     
    I am mighty! And this is a mighty small ad:
    free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
    https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
    reply
      Bookmark Topic Watch Topic
    • New Topic