How do i deploy MySQL Database to another computer?

[Ranhiru]

 

[Ranhiru]

coming back to the point...

Actually there are several ways to do it machang.

1. use a global address as the server address and let the application speak with it. e.g. store the database at http://ranhiru.com/db and allow the application to access it there.

2. create a DB dump. and then install the sql server in the client machine and re-run the dump to create the original DB back.

3. if there is no data in the database, install the server in the client machine and then use a script to create the required database tables quickly.


So I think you have to submit:
1. the application set up file
2. server setup
3. a script to create the tables and insert tuples or just the DB dump file.

Machan any idea on how to do the 2nd one??? sounds like a promising solution... i hope this DB dump file can be burned to the CD as well along with MySQL Server and given instructions on how to create the DB back... 3rd one wont work because there should be some data to test the app as well

 

[ashenrandika]

coming back to the point...

Actually there are several ways to do it machang.

1. use a global address as the server address and let the application speak with it. e.g. store the database at http://ranhiru.com/db and allow the application to access it there.

2. create a DB dump. and then install the sql server in the client machine and re-run the dump to create the original DB back.

3. if there is no data in the database, install the server in the client machine and then use a script to create the required database tables quickly.


So I think you have to submit:
1. the application set up file
2. server setup
3. a script to create the tables and insert tuples or just the DB dump file.

correct!
use MySQL administrator for creating and resoting the dump.
you can download mysql administrator setup from mysql download section.

 

[kosandpol]

Machan any idea on how to do the 2nd one??? sounds like a promising solution... i hope this DB dump file can be burned to the CD as well along with MySQL Server and given instructions on how to create the DB back... 3rd one wont work because there should be some data to test the app as well

run the command :
mysqldump -u root -p<rootpassword> database_name > /path/mysql_db_dump_filename.sql

 

[Ranhiru]

correct!
use MySQL administrator for creating and resoting the dump.
you can download mysql administrator setup from mysql download section.

ElaKiri machan!!! Got it!!! Did the backup and restore thingy in MySQL Administrator!!!!

 

[x-pert]

Machan any idea on how to do the 2nd one??? sounds like a promising solution... i hope this DB dump file can be burned to the CD as well along with MySQL Server and given instructions on how to create the DB back... 3rd one wont work because there should be some data to test the app as well

mysql reference manual for rescue

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


Well... personally even I myself would go with this option. But if you like some adventure try the 3rd.

Even if you have data, creating a script will work. All you need to do is, use the proper commands in a sequential order.

i.e. first Create DB, and then Create the independent tables, and then create the tables with foreign key references. then the indexes and triggers... and finally some INSERT into <table> statements which will populate the database...

Since it is a uni assignment, using MySql will show your ability for the assessors. But as kosandpol said once, the best solution for this kinda application is to use a simple access db. (just a personal opinion)

 

[Ranhiru]

run the command :
mysqldump -u root -p<rootpassword> database_name > /path/mysql_db_dump_filename.sql

Thanx! But using the MySQL Administrator's backup file was easy

Thanx again!!!

 

[Ranhiru]

mysql reference manual for rescue

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


Well... personally even I myself would go with this option. But if you like some adventure try the 3rd.

Even if you have data, creating a script will work. All you need to do is, use the proper commands in a sequential order.

i.e. first Create DB, and then Create the independent tables, and then create the tables with foreign key references. then the indexes and triggers... and finally some INSERT into <table> statements which will populate the database...

Since it is a uni assignment, using MySql will show your ability for the assessors. But as kosandpol said once, the best solution for this kinda application is to use a simple access db. (just a personal opinion)

I stopped using Access as all the lecturers said that Access is outdated and LAME

EDIT :-> Yeah 3rd one is really good if you only have to create the DB and only a small amount of sample data...but if you have a lot of data its not worth it ryt??

 

[x-pert]

I stopped using Access as all the lecturers said that Access is outdated and LAME

Looks like it has not changed a bit Same old Sri Lanka.

If it is obsolete, then why does it comes with the office suit still?

MS frontpage is outdated and they released Expression web now. But then why not Access?

Some lecturers are really stupid in some aspects and many thinks that they know it all!

We should think about the 'most suitable' option. Not the most advanced option

Anyway.. it's not your issue machang. Just the lack of experience in the industry within that community...


Edit >> yes. if you have a lot of data, then creating a dump is the most feasible option

 

[Ranhiru]

Looks like it has not changed a bit Same old Sri Lanka.

If it is obsolete, then why does it comes with the office suit still?

MS frontpage is outdated and they released Expression web now. But then why not Access?

Some lecturers are really stupid in some aspects and many thinks that they know it all!

We should think about the 'most suitable' option. Not the most advanced option

Anyway.. it's not your issue machang. Just the lack of experience in the industry within that community...


Edit >> yes. if you have a lot of data, then creating a dump is the most feasible option

ohh hehe ok...because first they said to use Access...and later the 2nd project they asked to use SQL Server because they said its the industry standard....well i've never being to the industry so i used SQL Server ...and so did most of the other colleagues. and thanx loadz again machan!!! The SQL Administrator's Backup and Restore worked like a miracle!!!!

 

[daya2007daya]

problem in debugging

I have developed an application using Visual Basic .NET 2008 which uses a MySQL Database. The connection string i use is something like
Server=myServerAddress;Database=myDataBase;Uid=myU sername;Pwd=myPassword;
so actually the server is localhost, database name is customers(or watever!), and uid=root and pwd is *****
so everything works fine...now this program is something which i need to run on other computers as well....so do i have to install mySQL server to each and every computer that i need to run this software? cant i get a single database like MS SQL Server ?? .mdf,.Ldf or.sdf??? Plz help me! and if possible please tell me or post a website which can help me deploy the database to another computer to use.
This is a project which i need to submit to my university so plz tell me what i files i need to burn on to the CD that im submitting and any special instructions that i should include in the CD to run the project
Thanx loadz in advance

 

[daya2007daya]

I have developed an application using Visual Basic .NET 2008 which uses a MySQL Database. The connection string i use is something like
Server=myServerAddress;Database=myDataBase;Uid=myU sername;Pwd=myPassword;
so actually the server is localhost, database name is customers(or watever!), and uid=root and pwd is *****
so everything works fine...now this program is something which i need to run on other computers as well....so do i have to install mySQL server to each and every computer that i need to run this software? cant i get a single database like MS SQL Server ?? .mdf or .sdf??? Plz help me! and if possible please tell me or post a website which can help me deploy the database to another computer to use.
This is a project which i need to submit to my university so plz tell me what i files i need to burn on to the CD that im submitting and any special instructions that i should include in the CD to run the project
send information on my email: [email protected]
Thanx loadz in advance

 

[x-pert]

I have developed an application using Visual Basic .NET 2008 which uses a MySQL Database. The connection string i use is something like
Server=myServerAddress;Database=myDataBase;Uid=myU sername;Pwd=myPassword;
so actually the server is localhost, database name is customers(or watever!), and uid=root and pwd is *****
so everything works fine...now this program is something which i need to run on other computers as well....so do i have to install mySQL server to each and every computer that i need to run this software? cant i get a single database like MS SQL Server ?? .mdf or .sdf??? Plz help me! and if possible please tell me or post a website which can help me deploy the database to another computer to use.
This is a project which i need to submit to my university so plz tell me what i files i need to burn on to the CD that im submitting and any special instructions that i should include in the CD to run the project
send information on my email: [email protected]
Thanx loadz in advance

Please read the whole thread Solution is already posted within the thread.

 

[Ranhiru]

Please read the whole thread Solution is already posted within the thread.

hehe this guy has copied the same thing which i posted and added his email address...

 

[kosandpol]

hehe this guy has copied the same thing which i posted and added his email address...

He's working on the same project too ?