About my VPS (database) phpMyAdmin

[Gidz Cross]

Since my provider doesnt want to response any of my message i decided to ask help here. Im not even sure if im in the correct section. Well this is about adding sql query to add tables. On my test server i can do it with no problem because i know how to use mysql workbench. But this is different. I might messed up my database. Because my server is already live. I dont wanna risk it. Can anyone help me?

Well this is my problem.

I want to add this line.

 

Spoiler

create table pvpladder (
	char_id int(11) not null default '0' primary key,
	name varchar(30) not null default '',
	streaks smallint(6) unsigned not null default '0',
	kills smallint(6) unsigned not null default '0',
	deaths smallint(6) unsigned not null default '0',
	streaktime datetime
) engine = myisam;

create table ownladder (
	guild_id int(11) not null default '0' primary key,
	name varchar(24) not null default '',
	currentown smallint(6) unsigned not null default '0',
	highestown smallint(6) unsigned not null default '0',
	owntime datetime
) engine = myisam; 

 

like i said using mysql workbench i can double lick the rathena schema and add a query with no problem. 

This is the screenshot of my vps's phpMyAdmin (I dont know what to call it)
 

 

Can anybody guide me? The one i encircled is the schema required to use the script to make tables. Somebody? I thankyou bigtime in advance!

Edited December 22, 2019 by gidzdlcrz

[Ice Bear]

click ragnarok goto SQL TAB there will be a input box you will put the sql code inside and execute but first i highly recommend that you test this offline in your pc just to make sure that these tables wont affect anything.

[Gidz Cross]

1 minute ago, Ice Bear said:

click ragnarok goto SQL TAB there will be a input box you will put the sql code inside and execute but first i highly recommend that you test this offline in your pc just to make sure that these tables wont affect anything.

Thank you @Ice Bear for the reply. I already tried this to my test server offline. Can you please guide me more? I will try to do what you told me.

So should i click the one i encirled?

[Ice Bear]

no the SQL one

the one after Structure Tab

[Chaos92]

Click SQL and execute your .sql-files there.

[Gidz Cross]

@Ice Bear

So it should be like this?

[Ice Bear]

On 12/22/2019 at 8:59 PM, gidzdlcrz said:

@Ice Bear

So it should be like this?

yes and click GO Button

also if you encounter .sql files upload you can refer to what @Amir Azman saying you can import if the file is in .sql format. that is located in the import tab , export that should be you know

[Gidz Cross]

Arrrr!! It worked! I thank you guys! Upvote to each and every who reply on this matter. ♥