shammer Posted February 26, 2003 Posted February 26, 2003 I have a script with the file ticketsystem.sql and it has a sql dump that I need to import into a MySQL DB. How do I do this? I tried to use restore but it isn't a gz file so restore wouldn't work. Quote
TCH-Rick Posted February 26, 2003 Posted February 26, 2003 Is this a script to set up your database? I've seen that with several scripts. To use it you create your database and then go to phpmyadmin and select it. Then you go to the SQL tab (at the top) and then can use Browse to select the file on your computer and hit Go. It should then give you a message to let you know whether it was succesful or had errors. Quote
shammer Posted February 26, 2003 Author Posted February 26, 2003 Yes, that is exactly what it is, and that is exactly what I need. Too bad there is an error in line 1. Quote
shammer Posted February 26, 2003 Author Posted February 26, 2003 Lianna, I was actually trying to get a different helpdesk script installed, I wanted to compare them. I can't get either one to work import the tables right. Quote
Lianna Posted February 27, 2003 Posted February 27, 2003 Well darn. Let me look at the first one tonight and I'll see how far I can get. I'm still figuring that the error in Line1 of this one is the same potential pitfall of the other...shared MySQL resources. See the DB name on the shared resource is going to append "username_" to the front of the db name. If the dump is hardcoded for a particular db name, then it's gonna blow. See? Let me look. Lianna Quote
shammer Posted February 27, 2003 Author Posted February 27, 2003 yes, that is exactly what I thought. Anyone know of a simple and easy to install on TCH helpdesk script? Quote
Lianna Posted February 27, 2003 Posted February 27, 2003 I got it. (These notes all refer to installation of phphelpdesk as found at sourceforge) Two things, one less complicated than the other and I have several other installation notes for you. 1. The database name references can be modified in the config files to accomodate the shared MySQL resources. Not tricky. This will also apply to the database username and password. 2. To run the dump, you just do the build manually. Simply use the SQL capability in phpMyAdmin by copying the dump commands into the phpMyAdmin SQL command textbox. You edit the dump file and just remove all the fluff till you get to barebones. By that, I mean remove all extra line breaks, remove all mid-command carriage returns, remove all comments. Copy that code and paste it into phpMyAdmin and click Go. (shammer, I'll send you the cut file in a bit). Now, I'm still working some of the config icky bugs, but for the most part, it's functional and I didn't need server root to do it. Li Quote
shammer Posted February 27, 2003 Author Posted February 27, 2003 you are too good at this stuff. Quote
Lianna Posted February 27, 2003 Posted February 27, 2003 Apparently not good enough. This app is REALLY buggy. I just spent the morning going through the sourceforge tracker and debugging only to be in no better situation with the app itself. (..but the database is fine ) Let's find a different solution. The phphelpdesk app is not my idea of stable. Lianna Quote
rayners Posted February 27, 2003 Posted February 27, 2003 We could always write our own. (famous last words...) Quote
rayners Posted February 27, 2003 Posted February 27, 2003 Well, I have been itching for an app-level PHP project lately. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.