Fermé

help restoring mysql database

trying to restore a mysql database and it wont work and need help. Have tried via command prompt and via the mysql administrator. when I type from the command prompt i am typing mysql -u root -ppassword DatbaseName < [login to view URL] it then comes up with the error ERROR 2006 (HY000) at line 70: MySQL Server has gone away When trying to do it from mysql administrator it says it works but has only restored about 1 table (should be many tables) and also give alot of errors. the start of the errors is below It is running on windows 2008 server standard edition mySQL is 5.1.30-community I don't anything about the mySQL database it was backed up on, nor can I get access to that computer again. so all I have is a backup file.

## Deliverables

Deliverables is a solution written down that I can implement and it works Warning: Do not know how to handle this statement at line 14: CREATE DATABASE /*!32312 IF NOT EXISTS*/`sugarpro_sourcemm_com_au` /*!40100 DEFAULT CHARACTER SET latin1 */; Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized. Error while executing this query:insert into `accounts`(`id`,`name`,`date_entered`,`date_modified`,`modified_user_id`,`created_by`, `description`,`deleted`,`assigned_user_id`,`team_id`,`account_type`,`industry`, `annual_revenue`,`phone_fax`,`billing_address_street`,`billing_address_city`, `billing_address_state`,`billing_address_postalcode`,`billing_address_country`,`rating`,`phone_office`, `phone_alternate`,`website`,`ownership`,`employees`,`ticker_symbol`,`shipping_address_street`, `shipping_address_city`,`shipping_address_state`,`shipping_address_postalcode`, `shipping_address_country`,`parent_id`,`sic_code`,`campaign_id`,`account_code`) values ('2fd3bf53-416a-b051-23b3-4830385c418e','CLP0010000 (Aaron) Tua None','2008-05-18 04:50:14','2008-08-31 19:18:04','1','1',NULL,0,'1','1',NULL,NULL,NULL,NULL,NULL,'','','','New Zealand',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8b775224 -9c80-c481-632a-4872e01e1958',NULL,NULL,'CLP0010000'), ('459833b9-73bb-e610-3588-483038425860','CLP0010001 3D Home Loans','2008-05-18 04:50:14','2008-08-31 20:47:14','1','1',NULL,0,'1','d96f004f-c718-f9c9-eaff- 488855604b8f',NULL,NULL,NULL,NULL,NULL,'','WA','','Australia',NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CLP0010001'), ('619fb7bd-7598-3c25-6bbf-48bb03dfb8a0','CLP1080261 John Hutch','2008-08-31 20:47:50','2008-10-09 00:26:23','74eee911-daff-0381-1a07-47b38309effb','1',NULL,0,'1','1',NULL,NULL,NULL,NULL,NULL,NULL,'Hawkes Bay','4001','New Zealand',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'b5692583 -0e98-de8f-1826-4872d3c03091',NULL,NULL,'CLP1080261'), ('5a8e7be9-fe0b-e999-9739-48303843df44','CLP0010002 3D Home Loans None','2008-05-18 04:50:14','2008-08-25 01:44:48','426c5407-ce74-3b58-8993- 468b21c3e9a9','1',NULL,0,'1','1',NULL,NULL,NULL,NULL,NULL,'','','Unknown','NULL',NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CLP0010002'), ('d903c000-cee2-11bd-ab71-48b4d5955fc7','CLP1070105 Lucy Andrews','2008-08-27 04:16:03','2008-08-27 04:16:03','74eee911

## Platform

It is running on windows 2008 server standard edition mySQL is 5.1.30-community

Compétences : Tout va bien, MySQL

en voir plus : work wa, work from home administrator, work at home database, work at home australia, wa australia, mysql database server, it works community, how to access work computer from home, how to access home computer from work, database administrator work from home, database administrator australia, community work australia, australia works, mysql 5.1, 3d work from home, sql server database administrator, sql database report, name new zealand, mysql report, mysql database

Concernant l'employeur :
( 207 commentaires ) Australia

Nº du projet : #3667583

12 freelance font une offre moyenne de $64 pour ce travail

gopisoft

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(62 Commentaires)
5.6
vw2224251vw

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(52 Commentaires)
5.6
aadverbsfi

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(37 Commentaires)
4.6
singhnamita

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(18 Commentaires)
3.7
acer2004UK

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)
3.6
dumadani

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
1.9
zaldz

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
0.8
neodreamlx

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
1.9
creativecoderz

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
3.3
erichardvw

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
info2ram

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
blackcatsteam

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0