sila Posted November 19, 2006 Posted November 19, 2006 After looking for quite some time I have not found the answer to this question: I want to use cpanel's phpMyAdmin for a complete sql database backup (to be sure I really catch all the tables for certain). In phpMyAdmin's export section, there are a number of sql export options for structure and data. Structure: Add DROP TABLE Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes Data: Complete inserts Extended inserts Maximal length of created query (50000) Use delayed inserts Use ignore inserts Use hexadecimal for binary fields Which are the correct options to select/not select? Thanks for helping!
ComicWisdom Posted November 19, 2006 Posted November 19, 2006 After looking for quite some time I have not found the answer to this question: I want to use cpanel's phpMyAdmin for a complete sql database backup (to be sure I really catch all the tables for certain). In phpMyAdmin's export section, there are a number of sql export options for structure and data. Structure: Add DROP TABLE Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes Data: Complete inserts Extended inserts Maximal length of created query (50000) Use delayed inserts Use ignore inserts Use hexadecimal for binary fields Which are the correct options to select/not select? Thanks for helping! If you are backing up directly to a database on your server. First make sure that you have created the database and that your username has dba priviledges in both. Then goto operations down to the section copy database. Unclick Create Database Check Add drop Fill in the name of the database you are copying to... it is your user name plus _ plus db name Click go If you are trying to export to your desktop Click export Best bet is to use Sql 4 compatibility enter name of file you would like to save to click go Oh, and make sure both sturcture and data are checked in either instance Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!! Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience. The quickest way to learn is to forget to BACKUP!
sila Posted November 27, 2006 Author Posted November 27, 2006 Thanks for your help. I am moving to another hosting service, that is I need to reinstall a heavily modified OSC on a new server. Hopefully I can save the database properly before the old hosting service runs out at the end of this month! I understand that i will create a new (empty) database on the new server, make sure I add a user to it with priviledges to import the tables to it. To make sure, I'll make the database name and username on the new server exactly the same as on the old server. (I will tinker with this after I'm sure it runs ok). I do need to export the database properly from the old server using the current standard cpanel /phpmyadmin. The export requires me to checkmark a number of SQL export options and this is the problem, I have no idea which options to checkmark. The following are each checkable options, each checkbox represented by a "+" here: + Structure: + Add DROP TABLE + Add IF NOT EXISTS + Add AUTO_INCREMENT value + Enclose table and field names with backquotes + Data: + Complete inserts + Extended inserts + Maximal length of created query (50000) + Use delayed inserts + Use ignore inserts + Use hexadecimal for binary fields Clearly the main headings/options "structure" and "data" must be checked. For my phpbb message board, the instructions were to checkmark: "structure", "add drop table", "add if not exists", and "data", "complete inserts", extended inserts", all others are not checked. That worked perfectly for the phpbb message board. Question is, from the above, what are specifically the options that need to be checked (and which must not be checked) for properly exporting the OSC tables?
sila Posted November 29, 2006 Author Posted November 29, 2006 Well, I've got two more days to download it. Is there anyone who can help with this?
pyramids Posted November 29, 2006 Posted November 29, 2006 If both sites have cPanel (or equivilent) then - I suggest that you ask the new server host to move the entire site for you, a good host will do it for free. Then all you need to do is tweak the new site settings and point the dns.
sheldonlg Posted November 29, 2006 Posted November 29, 2006 Well, I've got two more days to download it. Is there anyone who can help with this? I would export the db tables to a text file on your local computer. I would then look at what you have. I would import those onto the new host and check that you match with the old host (in the next two days :-) ). If what you get in the file or in the new host are not what you want, try again with one or the other option turned on or off. When I did an export to go from one host to another, I did it with the structure, data, and add/drop. I then manually deleted the drop table commands. I then ran the sql commands from a cut and paste from the edited file. It worked for me. Shelly
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.