I'm not sure, databases are secondary for me as I'm programmer. If you have knowledge of SQL you may try to import back database in chunks of data.

Next time please click on "Flag Bad Post" and write message like "Please move to PHP" and assign moderator will take care of it.

Did you created "info" database before importing or you expected to be on sql file processing?

If you checked box in installation to set path for MySQL you need to only call mysql -u USERNAME -p followed by password after system request. In case you didn't do it, you need to navigate command...

Strange, try this there is virtually no difference just after executing you need to provide password.
mysqldump -u root assignment2 > HW1.sql -p

If this doesn't work try to install MySQL GUI...

If you let MySQL register its PATH on install you can run dump from any location in your pc, if you did not do so you need to run dump from MySQL installation folder. Point of this is that you do not...

That bit you can do on your own by searching law in regards of IT and data protection of your country that varies between countries

Just two more things

There is java2s.com (http://www.java2s.com/Tutorial/Java/0340__Database/Catalog0340__Database.htm) site which hold number of examples, but no real tutorials with proper...

@Thirusha thank you for spreading word about it, but that is just one example with specific aim to show how database connectivity should be handled through servlets no Java Server Pages. However I...

In similar manner as you insert into table you can retrieve from table. Here is example from JSP section (http://www.daniweb.com/forums/thread141776.html)

/*
* Retrive data of single user
*/...

The WHERE Clause (http://w3schools.com/sql/sql_where.asp)

Try this (http://espressosoft.com/wordpress/?p=25)

Congratz on discovering and reposting what was already recommended...

iText (http://www.lowagie.com/iText/) free Java library for converting number of document types, or you can go for JasperReports...

This is trivial question and easily solved with some Google search so apply your self to this simple task and do it. If you have more specific question you more then welcomed to ask

Have look here (http://websec.wordpress.com/2007/11/17/mysql-table-and-column-names/) seems to be full of info

MySQL reference manual in regards of mysqldump (http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html), if this is not clear then you need to explain where you having difficulties

I see you already marked thread as solved. Did you get your solution? If so would you mind to share it with others?

Which DB is it (MySQL, MS SQL, Oracle, MS Access)?

That is option too, but it is not necessary to do as the above suggestion worked for me just few weeks ago and also not everyone is keen to re-install if you ask them:D

Try to re-run MySQL Server Instance Config Wizard (Start >> All Programs >> MySQL >> MySQL Server 5.1 >>MySQL Server Instance Config Wizard) as sometimes configuration may collide with other...

Please post your problem here. Solving issues over email or PM is against forum rules.

I never did anything like that so I can only suggest general direction.
These links looks promising and interesting

Firefox Extension Development Tutorial...

OK try this (http://expression.microsoft.com/en-us/dd571513.aspx)

PS: Would you mind to remove last link from your signature, adjult content is not allowed on this forum

Have look at this link (http://learnexpressionweb.com/sql-server-expression.aspx) could be helpful, for more in detail questions I recommend you put them in ASP.NET section

Are you familiar with either PHP, ASP, ASP.NET, JSP, Ajax or any other language suitable for web development and capable of database communication?

This doesn't make sense at all.
Can you provide more details on your requirements? What language you intend to use PHP/ASP/ASP.NET/JSP or any other?
There are tons of tutorials on SQLite...

Depending on what you using to read from browser/GUI application and which language you using Java/C#/PHP...

Check this out it should be helpful http://www.debianadmin.com/mysql-database-server-installation-and-configuration-in-debian.html

Knowing which technology you use collect data from form and query database would be nice...
PHP/JSP/ASP????

"Mark as Solved" bellow last post...

@k2k - when you buying web hosting the package says what it contains. These days only very basic and cheapest options do not include database in their offer. If you got one of these, then I have to...

This is not 24/7 service "my friend"!
time is DATETIME (http://dev.mysql.com/doc/refman/5.0/en/datetime.html) in MySQL, simple google search would sort such request...

Can you please explain what your trying to do?

Small recommendation for the future, use full names instead of 1-2 characters names. Once you start working on real projects and have to return to something you designed year ago for example you will...

I respectable disagree.
The site is missing on explanations to the code parts as it is only code solutions copy & paste from various resources. Explanations of most important parts of the code...

Thanx for confirming that for me

I was under impression that declaration of char(4) can store only values of exact length of 4 characters. However I was able to insert empty string and strings of less characters than 4.
Is there...

For the database import, before you attempt to import the "flat" file data in, you need go to your local DB (MySQL) and create new database
create database DATABASE_NAME;
After that you can import.

The error reffers to Connector/J not to instalation of MySQL. Do you have connector?
If not download it here (http://dev.mysql.com/downloads/connector/j/5.1.html). Extract the JAR file and place it...