copy database
Posted: Tue Mar 02, 2004 10:24 am
hi all,
i want to take a snap shot of the database and put into a text file. so i can run this query in mysql anytime and copy the database structure and data.
I only want to copy part of the data in the database but the full database structure.
for example i want to copy lets say i had a table called
tbl_login(uid,u_username),
tbl_location(lid,l_name),
tbl_school(scid,sc_name,frn_lid)
well i want to make a query which creates a text file with the entire data and structure of tbl_login table. For the tbl_location i want to take one record i specify in a query and the structure of the database and for the tbl_school table all the data relating to the tbl_location and the structure.
How can i do this?
i want to take a snap shot of the database and put into a text file. so i can run this query in mysql anytime and copy the database structure and data.
I only want to copy part of the data in the database but the full database structure.
for example i want to copy lets say i had a table called
tbl_login(uid,u_username),
tbl_location(lid,l_name),
tbl_school(scid,sc_name,frn_lid)
well i want to make a query which creates a text file with the entire data and structure of tbl_login table. For the tbl_location i want to take one record i specify in a query and the structure of the database and for the tbl_school table all the data relating to the tbl_location and the structure.
How can i do this?