need help with sql db

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   need help with sql db
gutchunks
CZ Newbie
gutchunks has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Apr 21, 2004
0.00 posts per day
Posts: 29
Points: 2,148
   
ok here is the scenario

im transfering a php-nuke 6.5 site from one host to another. ive uploaded the files exactly as they were on the old site to the new site. on the old site i went into the admin panel and backed up the database. i now have a .txt file of the db tables from the old site.i created a new database on the new site. i went into the config.php and changed the info to point to the new db. i went into phpmyadmin, SQL tab, and browsed to my .txt file from the db backup from the old site. i get the error 'NO SQL QUERY!' i googled the phrase and i read a bunch of posts basically saying that i need to alter the 'php.ini' file. specifically the...

max_execution_time = 30
memory_limit = 8M
post_max_size = 8M

the only problem is that i cant find the php.ini file. where is this water thing LOL and how do i fix this problem?

thanks in advance for any help you guys can offer



Back to top Reply with quote
#2   re: need help with sql db
echo
CZ Wiz
 Codezwiz Site Donator
Gender: Male
Status: Offline
Joined: Oct 04, 2003
0.15 posts per day
Posts: 1147
Points: 93
   
You will have to contact your new host and ask them to edit the php.ini file for you. Most host won't give access to that file for many important reasons.



Back to top Reply with quote
#3   re: need help with sql db
gutchunks
CZ Newbie
gutchunks has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Apr 21, 2004
0.00 posts per day
Posts: 29
Points: 2,148
   
i fingered it out... i just had to simply break my sql file into a bunch of smaller files all smaller than 1mb.



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum