The database that drives my site is really created and maintained on a computer in Microsoft Access. I use mySQL’s program “mySQL Migration Toolkit” to take the Access database and convert it into mySQL. After it is converted by “mySQL Migration Toolkit” I use a different program called “Core FTP” to grab the file off of the computer and upload the new mySQL file to my website’s folders on Dreamhost so that it is technically on my site but not yet uploaded/useable by the site via the Dreamhost Goodies panel.
For the purpose of my question, let’s call the database that is regularly updated and converted from Access “database1” and its single table “table1.” Since I don’t make a new Access database every time I want to update or add something, and my site’s queries are dependent on the names “database1” and “table1”, the name of the database and table do not change.
Can somebody possibly explain how I can overwrite the old copy of “database1” with the new copy of “database1”? I can see a button called “Modify” on the “Goodies” panel’s “Manage mySQL” screen but I can never seem to figure it out. I just end up hitting the “Delete” button and then panic because my entire site crashes and I have to run for help to the support team to get any of the FTP’d databases back online.
If you could possibly also not assume I have a clue about things like “command line” it would also be a big help, I don’t know what a command line is or where it comes from or even how to set one up. VERY basic instructions with beginning terminology are definitely most welcome and will be very much appreciated! Thanks in advance!