importing database from one pc to another

Thread view:

Vasu - 27 Nov 2005 05:19 GMT

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

Reply to this Message

Herman Timmermans - 27 Nov 2005 10:05 GMT

> hi all,
> i recently made a project in JSP and use MySQL as its DBMS, now the
[quoted text clipped - 6 lines]
> 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

Signature

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

Reply to this Message

importing database from one pc to another

Free Magazines