Database Upload Error

[kronnos]

Hi,

I wanted to upload a database from my old hosting provider but received the error below.

Error

SQL query:

--
-- Database: `plazma_forum`
--
-- --------------------------------------------------------
--
-- Table structure for table `access`
--
DROP TABLE IF EXISTS `access` ;

MySQL said: Documentation
#1046 - No database selected

The entire database is about 23megabytes.

Also, is there a way to copy the database directly from one server to another, without having to download to computer and upload it?

BTW, i tried to upload via phpmyadmin, i did export and then import where needed.

Thank You

[Dismounted]

Make sure you have created a database on the account and clicked into that database in phpMyAdmin before clicking "Import".

[kronnos]

Oooh! So I should have created a database called "plazma_forum" and a user for that database right?

Also, can I create a different name for this database since it was from old server and name is from old subdomain. Or maybe I can change the name somehow after I upload the database with its original name?

Thank You

[Dismounted]

You just need to create a database for the data to go into, the name does not matter.

[kronnos]

Thank, everything went perfect untill I got the next error, can you please help...

Error

SQL query:

INSERT INTO `bl_customavatar` (`userid`, `filedata`, `dateline`, `filename`, `visible`, `filesize`, `width`, `height`, `importcustomavatarid`) VALUES (412, 0x47494638396164006400f7fc00060301060a140d11090b11 18150a04140d1218120a1917151218 261d211a1a232f240c03250d1327140a251a15340c02320e12 371709361a142e1b252f231a292724 272a352c32282b3238362a25382a34383329383735101e401b 2b45361e452e37492d3d613b423839 44513950763d62744a1907461b3047210d4727184c350f4a31 1d5a2209552a185a350a58311c472b 24462737473429463935542c2554293a573528573a34641a13 6b1e29763717642c25632d35653928 643c33752b25752a33753b26743d34591d414e36465a3a6268 1c436b374d763c625e401c5045395b 613a77431a6f483767663a4d4b4b465a775a63535164786f54 4a6e5666736555706c6d3e5a80435c 804c6482725b826e7987687da278815a7984707686937994b0 7da0be7a9dc07da0c0813d1a823d27 853a548b3b64a53d6984411b884b33996319926637ab560da6 5538b56912a66c368758498d536d90 67548d756ca55b47aa5671a87057a97769c93d44c46e3ec072 3ed14f57ce5a6ec37257c87868e15e 71e77175965b83907585977ea1b15a84ad738eb87ba[...]

MySQL said: Documentation
#1153 - Got a packet bigger than 'max_allowed_packet' bytes

[Dismounted]

That error is caused by a low "maximum packet size" setting. This is handled inside the MySQL configuration file, and can usually only be changed if you have root access into the server.