File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes simple mysql questoion Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "simple mysql questoion" Watch "simple mysql questoion" New topic
Author

simple mysql questoion

Eric Howell
Ranch Hand

Joined: Nov 26, 2000
Posts: 63
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
Hartmut Ludwig
Ranch Hand

Joined: Aug 31, 2002
Posts: 51
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

    Joined: Nov 26, 2000
    Posts: 63
    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

    Joined: Nov 26, 2000
    Posts: 63
    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
     
    It is sorta covered in the JavaRanch Style Guide.
     
    subject: simple mysql questoion
     
    Similar Threads
    JBoss 4.0.4 is slow down in every 20 days
    SSL code returns HTTPClient.HttpURLConnection
    URlyBird: Data File Corrupted???
    String question
    Taking thread dump of Weblogic 8.1 in Solaris box