[Solved] Unable To Export Database From Phpmyadmin

[rahulawa]

unable to send email to gmail id

with

smtp.gmail.com

 

http://rajesha1.heliohost.org/cmis/NewFile.jsp

 

unable to see error also

 

 

sending email from localhost with my computer

 

u can check ur console and tell me what the error is

Edited September 11, 2017 by rahulawa

[rahulawa]

SQLException: Packet for query is too large (5526600 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

SQLState: S1000

VendorError: 0

while establishing remote sql client with java

Edited September 22, 2017 by rahulawa

[rahulawa]

reply please

[wolstech]

Krydos will look at this when he gets a chance. 24-48 hours wait can be normal at times.

[Krydos]

Posted Today, 02:12 AM

I've already explained several times that I'm not usually awake at 2am. I've also explained that you should try to be more patient in the future. If you're having trouble understanding either of these points let me know and I'll try to find a better way to explain it.

 

The mysql max_allowed_packet is already set to 256 mb, which should be more than large enough for anyone, and not 1 mb like your error message shows. Googling your error though I found this https://stackoverflow.com/questions/13759418/com-mysql-jdbc-packettoobigexception which says that if you use the wrong connection string you can get that misleading error even though the max_allowed_packet is set correctly.

[rahulawa]

Connection conn = null;

try {

 

conn=DriverManager.getConnection("jdbc:mysql://tommy.heliohost.org:2083/db?","user","pass");

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select something from table");

while(rs.next())

{

System.out.println(rs.getInt(1));

}

// Do something with the Connection

} catch (SQLException ex) {

// handle any errors

System.out.println("SQLException: " + ex.getMessage());

System.out.println("SQLState: " + ex.getSQLState());

System.out.println("VendorError: " + ex.getErrorCode());

}

 

is this connection is ok

because still the same error of packet too large

Edited September 23, 2017 by rahulawa

[Krydos]

Yeah, there's your problem. Mysql is port 3306 not 2083.

[rahulawa]

Access denied for user 'rajesha1_root'@'myip' (using password: YES)

Edited September 23, 2017 by rahulawa

[Krydos]

Did you enabled remote mysql connections?

[rahulawa]

it is working now but only if i add “%.%.%.%”

as host

[Krydos]

% is a wildcard in sql so one % will match all IPs. %.%.%.% is kind of overkill, but it works.