Re: importing database from one pc to another



Vasu wrote:

> hi all,
> i recently made a project in JSP and use MySQL as its DBMS, now the
> project is complete and i have to copy it from my PC to the PC on which
> we will give the presentation, but when i try to copy MySQL data from
> my PC to my friend PC i face some problems,
> first i create the database on friend's PC with same name and
> privileges and then copy and paste the tables data from my PC to his
> PC, now "show tables;" command is working but when i try to see tables
> content it is giving some error (i think 501), we both have MySQL
> 4.1-nt, now what should i do, Plz. help me


Why do you think this is a database problem ? Error
501 is an http status code meaning : "NOT IMPLEMENTED - the sever does not
support the facility requested."
What Servlet container are you using? Tomcat? What version? What version
JSP? Are the containers configured the same ?
Can you query your database using a console session, like :
#mysql -u yourdbusername -p yourdbpassword
mysql>
mysql>show databases;
+--------------------+
| Database |
+--------------------+
| mysql |
| yourdb |
+--------------------+

mysql> use yourdb;
Database changed
mysql> show tables;
mysql> select * from oneofyourdbtables;
etc ....
If this works like you expects, your problem might be elsewhere.

Regards,
Herman
--
Suse Linux Professional 9.2 on Athlon 1.1 Ghz 512 Mb
Anti Spam = remove the "dot" and the "at"
Registered Linux User #264690
Visit us : http://users.skynet.be/herman.timmermans
.



Relevant Pages

  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: PICK OPENDB provides connection in shopping cart startup
    ... we MIS folks are required to take on tasks that we don't ... developer, nor the database. ... Why do you need MySQL?. ... in size that KTP experienced, evolving to the current 90,000+ sq. ...
    (comp.databases.pick)
  • Re: Java and MySql program example ?
    ... > I am trying to learn Java and need an example program with MySql ... > MySql database. ... Database connection established ...
    (comp.lang.java.programmer)
  • Re: Creating Mysql DB with PHP
    ... >> userID and password for that MySQL server. ... > I am only going by what I have to do when setting up a new database. ...
    (alt.php)