Find Jobs
Hire Freelancers

MySQL problem at magento website

$15-25 USD / hour

Đã đóng
Đã đăng vào gần 9 năm trước

$15-25 USD / hour

From what I understand there is a large innoDB MySQL database problem at my site silverinvest.no. I thought I had a backup through [login to view URL], but the backup was also corrupt, and could not be used to restore the site. I am not good with technical things, so first of all I need someone to find out if it is possible to fix the problem. If database can not be fixed, I want you to check if somewhere at [login to view URL]’s servers there is a version of the website from when we moved the site from a Norwegian host to [login to view URL] one year ago. If there isa one year old version of the site, can the website easily be rebuildt to how it was some days ago, but without the products, orders and customers that has been added the last year. I hope is it possible to fix the problem. If not, there is a chance that there is a version of the site. I remember it took some work to make the site work properly with new hosting company, but I hope this will not happen again. My last option will be to make a completely new site, but it has taken a lot of custom work to make the site work with automatic price updates for siler/gold/USD-prices, + other things, so it would be good to keep the old site. It is a Magento Pro site, so not Community or Enterprice. Below is some information from helpdesk at webhosting.uk.com. They are helpfull, and are probably able to help you, but could not fix the problems.. Kenneth: At the moment I can access [login to view URL] frontend, but when I try to [login to view URL] this message is at the bottom: "Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine' in /home/silver/public_html/lib/Zend/Db/Statement/[login to view URL] Stack trace: And if I enter Admin this message comes up: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine --We have tried to do the force recovery of the databases on the server. But unfortunately it is falling with the following error 150703 1:27:14 InnoDB: cannot calculate statistics for table silver_support/core_resource InnoDB: because the .ibd file is missing. For help, please refer to InnoDB: [login to view URL] 150703 1:27:14 [ERROR] MySQL is trying to open a table handle but the .ibd file for table silver_support/core_resource does not exist. Have you deleted the .ibd file from the database directory under the MySQL datadir, or have you used DISCARD TABLESPACE? See [login to view URL] how you can resolve the problem. The table core_resource does exists in the database but the above error is indicating corruption of the Innodb storage engine on the server. we have tried to restore the database from the backup but it is not helping much as the backup package which you have is having only 1 retention point and the backup which is is there is also corrupted. Kenneth:Maybe 3-4 weeks ago I removed some "stores" in Magento. I had separate stores for different languages, but I removed these to see if that would help on the problems with low memory, causing the site to stop working. But its strange if this should make a database problem now, several weeks later? As per our previous update INNODB databases get corrupted , so it is not possible to recover them on server. The only way is to recover database from the database backup file. "SQLSTATE[HY000] [2002] No such file or directory" [login to view URL] is now being routed to our facebook-page, but his is the latest error frontend on the site [login to view URL] is now being routed to our facebook-page, but his is the latest error frontend on the site Error in file: "/home/silver/public_html/app/code/core/Mage/Core/sql/core_setup/[login to view URL]" - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'silver_support.core_resource' doesn't exist
Mã dự án: 8029654

Về dự án

39 đề xuất
Dự án từ xa
Hoạt động 9 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
39 freelancer chào giá trung bình $22 USD/giờ cho công việc này
Avatar người dùng
Greetings, I have read Project Description & understood the whole situation, so please provide me your Hosting Panel details or cPanel, we can then quickly tell you what is the issue. Our current bid is just a placeholder, as we cannot submit the proposal without entering any amount but once you respond us, we can then finalize it. Look forward to hearing from you. Regards, YK LEADconcept
$25 USD trong 20 ngày
5,0 (63 nhận xét)
8,5
8,5
Avatar người dùng
Hi there..!! I have gone through your requirement and I am ready to work on this project. I have over 5 years of experience in Magento. I have completely understood your requirement and assure you with quality solution in a minimum of time. I can start the job immediately. Lets have a quick conversation on the details to proceed further with this project. Looking forward working with you. Regards, Ramcharan
$15 USD trong 15 ngày
5,0 (701 nhận xét)
8,4
8,4
Avatar người dùng
Hi, We are Certified pro in Magento. Kindly choose us so we can start the investigation and later take necessary steps to make the site go live. Regards Mouli
$26 USD trong 40 ngày
4,8 (247 nhận xét)
8,6
8,6
Avatar người dùng
Hi, With my 6 years magento development experience I can complete your task quickly and accurately. I would like to help you not only this task but also any future change or issue you might have.
$15 USD trong 30 ngày
5,0 (160 nhận xét)
7,1
7,1
Avatar người dùng
Hi, can I help you ? I am magento developer and designer, I am interested to work with you, I will do this job, can we discuss about project ? waiting for your reply. bye.
$25 USD trong 12 ngày
5,0 (163 nhận xét)
6,6
6,6
Avatar người dùng
Hello, My name is Paul. I from east Europe and work with magento more than 5 years. I have big exp in magento customization, fixing and etc. I can try help you...you can send me all files and DB..or give access to server wheere i will alble take backup...i will install all locally and trying run it....if i will able run then you will aply me. Last time then i fix DB issue - 2days ago.
$22 USD trong 3 ngày
5,0 (42 nhận xét)
6,4
6,4
Avatar người dùng
Hello, I am working on magento last 5 years. Over all 12 years on web development experience. you can give me chance to prove myself. I shall give you details in chat. I shall give you example site in the time of conversion. Thanks & regards pradip
$18 USD trong 10 ngày
5,0 (84 nhận xét)
6,0
6,0
Avatar người dùng
Hello we are a team of experienced php developers and designers. we have just started working together as a team of freelancers. before this, we had been working with local software companies. this is first time we are gathered for working on our own projects. we are four developers and one designer. we have more than 3 yr experience. we have worked on cms like wordpress, magento and joomla and frameworks like codeiginitor, zend framework(1 and 2) and also entity framework like symfony.. currently we are working to render some prototypes on our server, so that we can show it up to our clients and get projects. we are interested in your offer. please advise. Thanks AV
$21 USD trong 20 ngày
4,7 (69 nhận xét)
6,4
6,4
Avatar người dùng
Hello, My Name is Tudor,I'm from Romania. I have 4 years experience in magento. let see if i can solve your error . please contact me.
$22 USD trong 10 ngày
5,0 (55 nhận xét)
5,4
5,4
Avatar người dùng
Hello, I got over 10 years experience with MySQL and also with big databases, I can take a look at this one, from past experience sometimes its possible to recreate a database with problems with some effort but often it is also a lost, to have a picture about this case and if there is anything to recover, it would need access to the server. And since what you write only mention 1 table, it could be maybe possible to partitally recreate the database. Sincerly, Thorsten Sanders
$25 USD trong 3 ngày
5,0 (8 nhận xét)
4,4
4,4
Avatar người dùng
From your description it sounds probable that the current db-problems result from former disk-space problems. I don't know the automated backup-policy of your hoster, but there should exist any recent usefull db-dump. If reaaly there does not, it is possible to edit any recent db-dump taking out bad data successivelky until a working db-dump is reached. The mentioned db-table core_resources doess not contain any vital data but only the version-numbers of internal modules. But ... it cannot be ruled out, that this error-msg only is the starter of almost endless further errors, because config_resources is one of the early tables of magento in alphabet, and there are still hundreds to come.
$45 USD trong 2 ngày
5,0 (8 nhận xét)
4,1
4,1
Avatar người dùng
Hi, I am a computer teacher also as a system & network administrator. I am very interested with your project and I will done it as soon as possible. Please feel free to view my profile and I will waiting for your response to discuss this project to make a deal. Thanks & Regards, Suwandy
$18 USD trong 3 ngày
5,0 (16 nhận xét)
3,7
3,7
Avatar người dùng
I can do my best to solve this problem for you. I am available to start right away. I anticipate that this project will take about 4 or 5 hours, max. Let's discuss and get this problem taken care of for you!
$22 USD trong 10 ngày
5,0 (3 nhận xét)
3,1
3,1
Avatar người dùng
Hi, You should use SSH, enter into the server and then use raw Mysql Commands to take the backup of the DB, if anyone of the table is corrupted then u can take table by table till you find that the table is corrupted or missing. It is like working in MS-DOS and then only you can get the DB, the way you are tring will not work, I am afraid, If you know SSH or access to server through SSH then I can try to resolve the issue but need your online support till done, Please do buzz if I can be of help, Best regards, STG
$22 USD trong 3 ngày
4,9 (5 nhận xét)
3,2
3,2
Avatar người dùng
Hello Mate! I am interested in the project you posted. Their are lot of interested people here and they have lot of different things so i dont know you will reply me or not or even read my post or not but i want to let you know that we do have around 245 apps, 119 games and about 190 web based sites and softwares. I can even give you demo for it. I dont want to cheat you saying i did this and that but i want to say one word, if you will go with us you can definitely "TRUST" us. I WILL AGAIN SAY THAT I DONT KNOW THAT YOU ARE GOING TO READ ABOVE OR NOT BUT I WOULD ONLY SAY IF YOU CAN DISCUSS WITH US, YOUR PROJECT IS GOING TO BE DEFINiTE SUCCESS. Thanks Devang
$32 USD trong 3 ngày
5,0 (1 nhận xét)
3,2
3,2
Avatar người dùng
Hi, I am a developer for more than 7 years with experience in Zend 1 and 2, Magento, TYPO3, PrestaShop, PhoneGap etc. (backend and frontend) I can provide top quality work and the best practices. If you are interested, please feel free to contact me. Best regards, Andrei
$25 USD trong 10 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của NORWAY
Kvinesdal, Norway
5,0
4
Phương thức thanh toán đã xác thực
Thành viên từ thg 2 26, 2013

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.