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.<!--content-->
Is this a script to set up your database? I've seen that with several scripts. <br /><br />To use it you create your database and then go to phpmyadmin and select it. <br /><br />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. <br /><br />It should then give you a message to let you know whether it was succesful or had errors.<!--content-->
Yes, that is exactly what it is, and that is exactly what I need. Too bad there is an error in line 1.<!--content-->
Doh! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="
" border="0" alt="sad.gif" /><!--content-->
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. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="" border="0" alt="sad.gif" /><!--content-->
Well darn. Let me look at the first one tonight and I'll see how far I can get.<br /><br />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?<br /><br />Let me look.<br />Lianna<!--content-->
yes, that is exactly what I thought. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> Anyone know of a simple and easy to install on TCH helpdesk script? <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><!--content-->
I got it. (These notes all refer to installation of phphelpdesk as found at sourceforge)<br /><br />Two things, one less complicated than the other and I have several other installation notes for you.<br /><br />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.<br /><br />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.<br />(shammer, I'll send you the cut file in a bit).<br /><br />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.<br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> <br />Li<!--content-->
you are too good at this stuff. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tongue.gif" style="vertical-align:middle" emoid="
" border="0" alt="tongue.gif" /><!--content-->
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.<br /><br />(..but the database is fine <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> )<br /><br />Let's find a different solution. The phphelpdesk app is not my idea of stable.<br /><br />Lianna<!--content-->
We could always write our own. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><br /><br />(famous last words...)<!--content-->
HA! You funny MAN!<br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br /><br />...not.<br /><br />Li<!--content-->
Well, I have been itching for an app-level PHP project lately. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="" border="0" alt="biggrin.gif" /><!--content-->
Is this a script to set up your database? I've seen that with several scripts. <br /><br />To use it you create your database and then go to phpmyadmin and select it. <br /><br />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. <br /><br />It should then give you a message to let you know whether it was succesful or had errors.<!--content-->
Yes, that is exactly what it is, and that is exactly what I need. Too bad there is an error in line 1.<!--content-->
Doh! <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="
" border="0" alt="sad.gif" /><!--content-->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. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="
" border="0" alt="sad.gif" /><!--content-->Well darn. Let me look at the first one tonight and I'll see how far I can get.<br /><br />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?<br /><br />Let me look.<br />Lianna<!--content-->
yes, that is exactly what I thought. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> Anyone know of a simple and easy to install on TCH helpdesk script? <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><!--content-->I got it. (These notes all refer to installation of phphelpdesk as found at sourceforge)<br /><br />Two things, one less complicated than the other and I have several other installation notes for you.<br /><br />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.<br /><br />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.<br />(shammer, I'll send you the cut file in a bit).<br /><br />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.<br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> <br />Li<!--content-->
you are too good at this stuff. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tongue.gif" style="vertical-align:middle" emoid="
" border="0" alt="tongue.gif" /><!--content-->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.<br /><br />(..but the database is fine <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> )<br /><br />Let's find a different solution. The phphelpdesk app is not my idea of stable.<br /><br />Lianna<!--content-->
We could always write our own. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><br /><br />(famous last words...)<!--content-->HA! You funny MAN!<br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br /><br />...not.<br /><br />Li<!--content-->
Well, I have been itching for an app-level PHP project lately. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->