mysql cc

[chrisosx]

Can I use a MySQL Query not webbased?

Hi there. I'm working on a site with a friend of mine who got it hosted here, and well I'm the main person now. I'm trying to upload some MySQL queries with your included phpmyadmin, and well it isn't working so good for me. I try to upload the query as its a .sql file, and I keep getting the same error. I try with my MySQL server with mysqlcc and it works like a charm. I was wondering whats going on? And also can I use MySQL CC (Control Center) with x10hosting? If so, then whats the login/pass information? Thanks a bunch!

P.S. - I included my queries so can you check what the problem is?

 

[chrisosx]

We don't have MySQL CC or whatever it's called. Can you post the errors you get here?

-Auvee B.

mysql control center, its a query browser but not web based and is a lot freakin easier than this phpmyadmin thingy.. anyway lemme get the error out..

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'char(
char_id int(11) NOT NULL auto_increment,
account_id

 

[n4tec]

We don't have MySQL CC or whatever it's called. Can you post the errors you get here?

-Auvee B.

mysql control center, its a query browser but not web based and is a lot freakin easier than this phpmyadmin thingy.. anyway lemme get the error out..

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'char(
char_id int(11) NOT NULL auto_increment,
account_id

Is char the table? Wow why do you use 11 characters for a auto_increment..

Can you post the code aroung line 1064?

My task for you is to seach for phpmyadmin via google and compare it with MySQL CC..

thanx

 

[flankerdin]

HE trying to use this hosting to host his Ragnarok Database.......
I know because im a ragnarok private server hoster.......

 

[chrisosx]

We don't have MySQL CC or whatever it's called. Can you post the errors you get here?

-Auvee B.

mysql control center, its a query browser but not web based and is a lot freakin easier than this phpmyadmin thingy.. anyway lemme get the error out..

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'char(
char_id int(11) NOT NULL auto_increment,
account_id

Is char the table? Wow why do you use 11 characters for a auto_increment..

Can you post the code aroung line 1064?

My task for you is to seach for phpmyadmin via google and compare it with MySQL CC..

thanx

#1 Yes, char is the table.
#2 Its may take a while to count to 1064
#3 Um... ok?

 

[Richard]

Mysql CC is no longer under developement, its been that way for quite some time. phpMyAdmin is the way to go.

 

[chrisosx]

Mysql CC is no longer under developement, its been that way for quite some time. phpMyAdmin is the way to go.

i managed to get every other table to get in with some errors that i fixed, because the cells in the tables were named like syntaxs so i added an extra letter and then it went in and i changed it back to normal.

So my only thing is.. im stuck at the table CHAR... i don't get it.. lemme post it..

EDIT: I manage to get the main structure in by using the install files that i have but then when it comes to inserting the already made values from my older server (btw its 4.0.24-debug and the x10hosting server is 4.0.24-standard -- any difference?) and well.. it gives me errors again.. and its ALWAYS the first freaking line.. it pisses me off... i edited the code part so that its only what im trying to do...

---
-- Dumping data for table `char`
--
INSERT INTO char VALUES (15000,2000001,0,'Sakura',15,69,50,728911,1969771,921,52
,66,1,20,39,1,2971,2845,407,407,0,0,0,0,0,0,0,0,4,5,10,12,0,43,0,0,'prontera.gat
',156,184,'prontera.gat',156,191,0,0,0,0,0,0);
INSERT INTO char VALUES (15001,2000002,0,'GM-Rikku',12,87,1,1939258,0,603836,25,
104,6,5,55,9,4965,4965,375,375,6,0,0,0,0,0,0,0,18,5,9,16,0,67,82,52,'prontera.ga
t',154,180,'prontera.gat',156,191,0,0,0,0,0,0);
INSERT INTO char VALUES (15002,2000000,0,'GM-Bizzy',4015,53,1,151869,0,999913503
,1,69,1,1,34,1,5226,1454,339,130,20,0,0,0,0,101,0,0,4,0,0,0,0,0,0,0,'prontera.ga
t',53,204,'sec_in02.gat',179,76,0,0,0,0,0,0);
INSERT INTO char VALUES (15007,2000003,0,'GM-Sticky',4,59,50,24159,64991,392542,
1,9,1,72,45,1,1079,1079,533,533,2,0,0,0,0,0,0,0,1,5,0,8,2,16,63,8,'prontera.gat'
,171,216,'prontera.gat',156,182,0,0,0,0,0,0);
INSERT INTO char VALUES (15004,2000006,0,'I Love Christian',12,80,50,2251713,113
44233,6128,69,81,5,5,29,7,4282,4282,359,291,1,0,0,0,0,0,0,0,18,0,10,16,0,38,12,5
6,'prontera.gat',153,182,'prontera.gat',154,173,0,0,0,0,0,0);
INSERT INTO char VALUES (15017,2000022,0,'Soul',1,47,40,24066,2332,460,20,60,1,1
,27,1,1103,1103,105,105,0,0,0,0,0,0,0,0,18,6,0,2,0,41,0,0,'anthell01.gat',176,21
3,'new_1-1.gat',53,111,0,0,0,0,0,0);
INSERT INTO char VALUES (15008,2000007,0,'Deniska Grigorev',3,15,1,187,0,4529,5,
5,2,5,26,5,176,131,42,40,1,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,'prontera.gat',160,163,
'new_1-1.gat',53,111,0,0,0,0,0,0);
INSERT INTO char VALUES (15011,2000007,2,'Arkleseizure',1,17,1,78,0,0,29,5,5,1,5
,5,238,238,44,44,3,0,0,0,0,0,0,0,1,1,4,2,0,86,0,0,'prontera.gat',133,210,'pronte
ra.gat',33,208,0,0,0,0,0,0);
INSERT INTO char VALUES (15009,2000007,1,'Rygar',9,62,50,267870,219996,1961,9,2,
1,85,30,1,1448,1448,1118,1118,1,0,0,0,0,0,0,0,3,7,12,1,1,67,47,0,'jawaii.gat',24
9,127,'prontera.gat',33,208,0,0,0,0,0,0);
INSERT INTO char VALUES (15010,2000010,1,'Celestine',13,61,49,100838,65095,52336
,70,9,1,1,50,1,3540,3464,209,194,18,1,32,0,0,0,0,0,17,0,0,2,0,38,63,56,'alde_dun
01.gat',290,26,'prontera.gat',151,183,0,0,0,0,0,0);
INSERT INTO char VALUES (15012,2000001,1,'HarunoSakura',11,90,50,692106,37349093
,405408,22,21,1,1,126,1,4087,3156,388,324,6,0,16,0,0,0,0,0,3,0,0,11,0,72,83,56,'
prontera.gat',156,191,'prontera.gat',153,179,0,0,0,0,0,0);
INSERT INTO char VALUES (15013,2000002,1,'Zell',4,54,46,2668,14635,595,20,32,1,5
0,40,1,934,934,428,428,1,3,64,0,0,0,0,100,7,1,0,8,0,67,0,0,'orcsdun01.gat',148,1
30,'new_1-1.gat',53,111,0,0,0,0,0,0);
INSERT INTO char VALUES (15014,2000008,0,'Guan Yu',1,16,1,496,0,500,9,9,9,1,24,1
,228,228,42,42,1,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,'prontera.gat',157,162,'new_1-1.g
at',53,111,0,0,0,0,0,0);
INSERT INTO char VALUES (15015,2000018,1,'~[naruto]~',3,13,1,424,0,500,1,9,1,9,2
4,1,149,102,39,27,1,0,0,0,0,0,0,0,12,1,0,1,0,0,0,0,'prontera.gat',154,178,'anthe
ll01.gat',32,263,0,0,0,0,0,0);
INSERT INTO char VALUES (15016,2000019,0,'.:TIM:.',7,49,1,37320,0,280,49,49,5,5,
5,5,2255,2255,164,164,0,0,0,0,0,0,0,0,18,5,10,2,0,41,0,56,'prontera.gat',160,153
,'prontera.gat',154,179,0,0,0,0,0,0);
INSERT INTO char VALUES (15018,2000023,0,'DeathDealer',6,13,1,424,0,500,9,20,1,1
,15,1,149,149,36,36,0,0,0,0,0,0,0,0,19,1,0,1,0,0,0,0,'prontera.gat',156,178,'new
_1-1.gat',53,111,0,0,0,0,0,0);

 

[chrisosx]

so i can't access my sql server via MySQL Control Center or Query Browser!??