Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 16 Jan 2009, 15:18
fahl fahl is offline
 
Join Date: Feb 2008
Mysql database cleanup

Is there any way other than going thru it totally by hand to clean a database back to the original tables.
Thanx
Reply With Quote
  #2  
Old 16 Jan 2009, 15:27
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
You could create a new empty forum and use ImpEx to transfer the data. But this will change all your links so older search results will not work anymore.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #3  
Old 16 Jan 2009, 15:30
Aclikyano Aclikyano is offline
 
Join Date: Apr 2006
^ that would suck....

i have to update to mysql5 asapppp cause im getting some errors now smh
Reply With Quote
  #4  
Old 16 Jan 2009, 15:33
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Maybe we can give a better advise if you post the errors you are getting.

PS Upgrading MySQL would not be related to the contents/data of the database.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #5  
Old 16 Jan 2009, 15:37
Aclikyano Aclikyano is offline
 
Join Date: Apr 2006
Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408 Database error

--------------- Added 11:38 AM at 01-16-09 [Fri] ---------------

a couple users on my board are getting that when tryin 2 access one section....


now when i go to change my avatar, it works but at the top of the screen it gives me this code:

Warning: tempnam() [function.tempnam]: open_basedir restriction in effect. File() is not within the allowed path(s): (/home/crack:/usr/lib/php:/usr/local/lib/php:/tmp) in [path]/includes/class_dm_userpic.php on line 204

Last edited by Aclikyano; 16 Jan 2009 at 15:38. Reason: Auto-Merged DoublePost
Reply With Quote
  #6  
Old 17 Jan 2009, 15:18
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Is that the entire DB-error?

And the 2nd error has nothing to do with the database. It indicates you have not correctly setup your settings. Please consult your host for the correct open_basedir settings.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #7  
Old 17 Jan 2009, 18:41
Aclikyano Aclikyano is offline
 
Join Date: Apr 2006
well marco that is the whol error the user on my site is getting
Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408 Database error
Reply With Quote
  #8  
Old 18 Jan 2009, 10:46
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Is this with all modification disabled and using only the default vB files? If so, please open a support ticket.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:09.

Layout Options | Width: Wide Color: