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 Problem on exporting database from SQLBuddy 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 "Problem on exporting database from SQLBuddy" Watch "Problem on exporting database from SQLBuddy" New topic
Author

Problem on exporting database from SQLBuddy

Jc Frane
Ranch Hand

Joined: Aug 15, 2013
Posts: 32
Hi,

I am having a problem on exporting my database from sqlbuddy.
My SqlBuddy is pre-installed into my WAMP Server.

What I want to do is to transfer the database in my laptop into my groupmate's laptop but I have no idea how to do it.
I tried to search in google but nothing satisfies my needs.

Another problem is, I cannot access phpMyAdmin when I provide a password in accessing mySQL.
I think that importing/exporting database in phpMyAdmin is a lot better.

So anyone who can offer his/her suggestion on my problem?

Thank you so much in advance!
K. Tsang
Bartender

Joined: Sep 13, 2007
Posts: 2247
    
    7

Is the destination database also MySQL?

PHPMyAdmin is great tool but your computer will need to have PHP installed to access it. The most simplest thing is probably using mysql's mysqldump command. Then restore it in the destination server.

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html


K. Tsang JavaRanch SCJP5 SCJD/OCM-JD OCPJP7 OCPWCD5
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem on exporting database from SQLBuddy
 
Similar Threads
How to access a database over a network
code or server problem ?
mySQL connections
Character encoding to insert TimesPhoneticIPA text into mysql database
Can i connect to phpmyadmin using java