New Sight Transfer

[NSX665]

Hello. Was hoping that someone could help me out. We had been running on a freeware sight. After some deliberation we decided to go for a full on paywhere sight. We have been running for a few months now on the freeware sight. I am wondering. Do we have to start all over again with having to have everyone register and start all over with the flights or is there a way to transfer all the other information from our old sight into our new sight? I have attempted to copy the SQL information off the old web sight into the new web sight. In the my sql it is displaying all the information from the old web sight. But When going into the phpvms sight its not in there. What Must I do to get this to show up correctly.

Thanks

Error when transfering data base

SQL query:

-- -- Database: `a2695805_phpvms` -- -- -------------------------------------------------------- -- -- Table structure for table `phpvms_acarsdata` -- CREATE TABLE `phpvms_acarsdata` ( `id` int(11) NOT NULL auto_increment, `pilotid` varchar(11) collate latin1_general_ci NOT NULL default '0', `flightnum` varchar(11) collate latin1_general_ci NOT NULL default '0', `pilotname` varchar(100) collate latin1_general_ci NOT NULL default '', `aircraft` varchar(12) collate latin1_general_ci NOT NULL default '', `lat` varchar(15) collate latin1_general_ci NOT NULL default '', `lng` varchar(15) collate latin1_general_ci NOT NULL default '', `heading` smallint(6) NOT NULL default '0', `alt` varchar(6) collate latin1_general_ci NOT NULL default '', `gs` int(11) NOT NULL default '0', `depicao` varchar(4) collate latin1_general_ci NOT NULL default '', `depapt` varchar(255) collate latin1_general_ci NOT NULL default '', `arricao` varchar(4) collate latin1_general_ci NOT N[...]

MySQL said: Documentation

#1050 - Table 'phpvms_acarsdata' already exists

[Nabeel]

If you're using cPanel, have it do a database export. that will be the easiest way.

otherwise, make sure the destination database is empty before you import the .sql file in