[ethansql]

peterlaursen wrote on Sep 16 2005, 08:33 AM:

No you don't need to open port 3306 to run SQLyog!

If you run a MySQL server on your local machine and want to allow direct connection from a remote client then you must open port 3306 – no matter what client is used for connection.

More on routers and firewalls here:

http://www.webyog.com/faq/index.php?action…d=40&artlang=en

[post=”7191″]<{POST_SNAPBACK}>[/post]

will i be vulnerable to hackers if i open port 3306? how can i transfer files from SQLyog to my MySQL server if i don't open port 3306? please advise.

[ethansql]

i'm still having problems uploading a large db (about 3mb of data)… can anyone please help. i don't want to break the table into line by line like

insert into `tablename` values ('1001','first name1','lastname1','dob1','education1');

insert into `tablename` values ('1002','first name2','lastname2','dob2','education2');

seanhogge do you know how fix this? you're right, it gives me a line number error message like the following:

Line no.:23

Error Code: 2006 – MySQL server has gone away

please help. thanks,

also, if i break the file into pieces, will that work? if i do that i don't want the file that i just imported to override the previous import.

[ethansql]

Thanks everyone who contributed to this thread… i'm new to mysql and sqlyog so your insights are useful to my learning curve.

as i mentioned, when i tried importing a large textfile.sql that starts with the following:

USE `databasename`;

drop table if exists `databasename`.`tablename`;

CREATE TABLE `tablename` (

`col1` varchar(6) default NULL,

`col2` varchar(20) default NULL,

`col3` varchar(20) default NULL,

`col4` char(2) default NULL,

`col5` varchar(20) default NULL

) TYPE=MyISAM;

insert into `tablename` values ('1001','first name1','last name1','dob1','education1'),('1002','first name2','last name2','dob2','education2'),…..

here's the error message that i get:

Line no.:23

Error Code: 2006 – MySQL server has gone away

Line no.:23 is the line that starts with “insert into `tablename`values…..”

The weird thing is that if i just used 10-15 values (i.e. 1001… 1002…. 1003…. 1004… 1015), i don't get any error message. i didn't think this would be that difficult, but yet i'm still stuck not being able to import the database into the webserver.

[ethansql]

that's interesting. my version actually works if i don't try to export a junk of data.

i see that seanhogge's version works as well. thanks seanhogge for sharing your insights.

i'm frustrated that i'm still not able to upload the entire database. however, if i let my friend import it to the web server, it works fine… weird.

having said that, should the term be “export” instead of “import”? because i'm exporting the data on my computer to the webserver.

[ethansql]

ok i started from scratch… db exists but tablename does not exist… so i'm creating a table and inserting the values into the table… please tell me what's wrong with this text file… right now this is what i have and it's not working:

USE `databasename`;

drop table if exists `databasename`.`tablename`;

CREATE TABLE `tablename` (

`col1` varchar(6) default NULL,

`col2` varchar(20) default NULL,

`col3` varchar(20) default NULL,

`col4` char(2) default NULL,

`col5` varchar(20) default NULL

) TYPE=MyISAM;

USE `databasename`;

insert into `tablename` values ('57622','Cherry Creek','Ziebach','SD','South Dakota'),('57623','Dupree','Ziebach','SD','South Dakota'),…..

thanks,

[ethansql]

it's not working…. not sure how i should write the “insert into…” line that's why i posted on this board. please advise

[ethansql]

DB and table is there… now i'm updating the table.

[Author]

Posts