Kapalı

Migrate Magento store from local XAMPP development environment to web server

I have a Magento store that was built locally using XAMPP that I need to migrate to my shared hosting server. I have been able to get my template installed on the web server installation of Magento, but have not been able to import my local mySQL database successfully to the web store.

I need someone to complete the migration by successfully importing the .sql backup to the installation on my server. There are a couple of issues that have prevented me from doing so. A quick rundown of the issues I have experienced thus far:

I installed Magento locally using the Bitnami quick installer. This created the database, the name of which I could not replicate (bitnami_magento) on the server because databases on my sharing hosting server begin with my shared hosting user name as a prefix. Additionally, I could not replicate the root database admin used locally, and after importing to the web host would get site errors telling me that the users in the database did not have permission to access the database. I assume this is because the locally created and permitted users are stored in the .sql backup, but are not found as being active users with database access in my web hosting control panel.

After realizing this, I attempted to remove all user access on the local database in phpmyadmin then re-export, but also removed the root user, locking me out of access to my database and even the ability to see it as an existing database within phpmyadmin.

This is where my efforts ended, and I have been unable to restore access to the database locally or to import it to the web server without causing errors when trying to access the web installation.

I have the original backup .sql file of my local database.

I am looking for someone who knows mySQL databases, and preferably Magento too, who will be able to complete the migration by importing my database to the web server and getting it connected to the store and working as it was in the local development environment.

My assumption is that this will require editing of the mySQL backup file to change user permissions there, so that only database admins created on the web server and with access to the server database are listed with access in the .sql file.

However, I am not sure of this and will be looking to your expertise to determine how to resolve this problem. I am a front-end developer and am turning to Freelancer because I do not have the mySQL knowledge to do this without making it not worth the personal time investment relative to the other needs of the project.

Beceriler: Veri Tabanı Yönetimi, Magento, MySQL, Alışveriş Sepetleri

Daha fazlasını görün: xampp mysql import, working environment, working as a freelancer web developer, working as a freelancer sql developer, who is freelancer web developer, who did the web for freelancer, where i change my name on freelancer, web site quick developer, web site errors, web server development, web host site, web developer panel, web developer local, sql server developer freelancer, sql developer freelancer, sql database developer freelancer, site web developer freelancer, root freelancer, prefix problem, prefix of freelancer, personal web site template, personal freelancer web, on investment freelancer, need quick web developer, import export freelancer project

İşveren Hakkında:
( 2 değerlendirme ) AUSTIN, United States

Proje NO: #6272904

32 freelancer bu iş için ortalamada 154$ teklif veriyor

value4u

Hello, I am very familiar with Magento, please check my reviews for more information. Can you please send me the original backup sql file to check? Thanks, Kai

in 0 gün içinde50$ USD
(244 Değerlendirme)
8.9
wildCat

Hello. Do you need a team of certified FrontEnd/BackEnd Magento developers on full-time basis? You can find our portfolio at [url removed, login to view]

in 3 gün içinde263$ USD
(129 Değerlendirme)
7.7
p4provider

Hello, Can we have a small meeting on s*k*p ? we will discuss each and everything regarding your project , Quick reply will be appreciated , Let me know , Thanks p4provider

in 3 gün içinde263$ USD
(125 Değerlendirme)
7.7
nmans

We are highly interested to work with you on this project and can assure you quality results ready to start immediately some of our developed websites are listed below E-commerce [url removed, login to view] http://w Daha fazlası

in 10 gün içinde421$ USD
(165 Değerlendirme)
7.3
thetechie13

Hello, I can work on migrating Magento store from local XAMPP to web server. I'm a PHP expert worked on many sites in technologies like Magento, Corephp, wordpress, opencart, HTML5, responsive, website design, deve Daha fazlası

in 3 gün içinde200$ USD
(31 Değerlendirme)
6.6
iclicknetwork

Hi, Magento guru is here, i work and bid only in Magento within 4years. Please have a fair compare on reviews number, looking for long term work with Magento, I can start work immediately, daily report working progr Daha fazlası

in 3 gün içinde263$ USD
(67 Değerlendirme)
6.6
alifinteractive

Hi, We have a rich experience in magento website development and have completed many successful [url removed, login to view] can do this job with good understanding and in estimated time frame. Please check our some good works usin Daha fazlası

in 7 gün içinde157$ USD
(33 Değerlendirme)
6.5
JoomlaVogue

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - we(technical team) will review the job and as Daha fazlası

in 4 gün içinde164$ USD
(22 Değerlendirme)
6.3
zyeloncomputech

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can Migrate Magento store from local XAMPP development environment to web server according to your exact requirem Daha fazlası

in 4 gün içinde200$ USD
(58 Değerlendirme)
5.9
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Daha fazlası

in 3 gün içinde200$ USD
(61 Değerlendirme)
5.8
NextBitseu

Greetings Employer, We could easily able to do that for you even this Job could be done by any one who have a knowledge of Magento, you don't need to pay more cent for expert for this Job although we are applying Daha fazlası

in 3 gün içinde147$ USD
(5 Değerlendirme)
5.6
blueforestsun

Hi, i am a magento expert. I have carefully read this project .I can do it for you. Let me do it. Thanks.

in 3 gün içinde133$ USD
(30 Değerlendirme)
5.6
starcoadmin

Hello, I have reviewed your project posting and are very much excited to assist you in your project. I would appreciate if we can connect over private message or other medium to discuss about the project and provid Daha fazlası

in 4 gün içinde147$ USD
(4 Değerlendirme)
5.6
davaidwilliam

A proposal has not yet been provided

in 3 gün içinde147$ USD
(23 Değerlendirme)
5.3
zbsol

Lets start...................................................................................................................................

1 gün içinde 94$ USD
(16 Değerlendirme)
5.2
rsen75

hi, i'm 15+ years experienced with strong knowledge of API integration , Plugin development and designing see my few portfolio Prestashop theme and payment plugin - [url removed, login to view] **CSM and eCom** Daha fazlası

in 2 gün içinde130$ USD
(26 Değerlendirme)
5.0
mohidkhan

Hi, I am professional Programmer & designer of Front end & Back end, I am working with challenge and hope to improve future plan with good network every client. If you want to get more faster job services with save ti Daha fazlası

in 3 gün içinde147$ USD
(4 Değerlendirme)
4.5
matlidigital

Hi there We can do this we have a highly qualified team of magento designers and developers .We have completed many similar magento projects previously that is why we are confident we can complete this project in be Daha fazlası

in 3 gün içinde66$ USD
(25 Değerlendirme)
4.5
OBog

Hello! My name is Olga. I'm project coordinator at 4D code- 5 team that has 5 years experience in Magento development. We can provide migration by importing your database to the web server and getting it connected t Daha fazlası

in 5 gün içinde463$ USD
(7 Değerlendirme)
4.3
sasangagamlath

I am a Magento Developer since 3 years and I am working full time for an Australian based IT company. I can do this task. I need to know about the size of your DB and do you have Cpanel access for your server. Pl Daha fazlası

1 gün içinde 50$ USD
(11 Değerlendirme)
4.3