How can we load database?

**java19857** · 09-17-2008, 06:39 AM

Hi,

I am new to java and I need your help.

I want to load mysql database from flash drive into my local box. So, when I keep my flash drive my code should recognize file and start loading it. How can I achieve this?
Pls help me.

Thanks

**Eranga** · 09-17-2008, 06:43 AM

You mean that want to add your database from flash drive to the local drive?

**java19857** · 09-19-2008, 12:01 AM

No, I want to load the database from the script which is in my flash drive into local database. We are using MYSQL as our database. So, that i can create a batch such that when we click on that it immediately loads our database from our script.
Is there a way for this either in java (using xml ) or mysql.

Sorry for not being clear.
Pls help me.

Thanks

**Eranga** · 09-19-2008, 09:28 AM

Seems to me you are worrying how to do within the flash drive. If so you try it and fail, and what error message you get?

**java19857** · 09-19-2008, 05:59 PM

What I want to do is ,load my database with the script in my flash drive. for this I want to write a code it can be in java or mysql but again I need to make it as a batch so that once we insert our flash drive and click on it, the database should get loaded with my new script.

**fishtoprecords** · 09-19-2008, 06:34 PM

Why do you think you need to use java?
Have you looked at the standard scripting for Mysql?

The basics of what you want to do are trivial. Making the user experience wonderful will take some effort.