Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 15:53

  • Please register to post and access all features, it's quick, easy and FREE!

 

How to clear Rappelz databases to make fresh copy

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2008
Posts: 11
Received Thanks: 0
Post How to clear Rappelz databases to make fresh copy

Hi,
I would like to cleanup user data from rappelz databases.

Is there already some tool / sql script to do it, or just list of tables that needs to be cleaned=?

I have files from already used server, but it perform rather slow, and I was thinking to clear all not needed data and start fresh.

best regards,
S.
when does not help !!!



serafincro is offline  
Old   #2
 
elite*gold: 30
Join Date: Mar 2012
Posts: 632
Received Thanks: 287
Right click on database table -> Script table as -> DROP and CREATE.

Exception:

dbo.Dungeon -> there are a bunch of rows that are recommended to set default values manually, you'll see it clearly where you have to do this.

P.S. [Help Thread] Please post your questions here.


mongreldogg is offline  
Old   #3
 
elite*gold: 0
Join Date: Mar 2011
Posts: 253
Received Thanks: 330
Here is a script to completely clean telecaster.

Code:
DECLARE [MENTION=424982]table[/MENTION] VARCHAR(256)
DECLARE [Tables] CURSOR FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME <> 'AllowedCommandsForPermission'
AND TABLE_NAME <> 'Dungeon'

OPEN [Tables]
FETCH NEXT FROM [Tables] INTO [MENTION=424982]table[/MENTION]


WHILE @@FETCH_STATUS = 0
BEGIN
	EXEC ('TRUNCATE TABLE ' + [MENTION=424982]table[/MENTION])
	FETCH NEXT FROM [Tables] INTO [MENTION=424982]table[/MENTION]
END

CLOSE [Tables]
DEALLOCATE [Tables]
GO
xXExiledXx is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +1. The time now is 15:53.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.