MySQL - import .sql dumps to local dev machine
- or -
Post a project like this£140(approx. $175)
- Posted:
- Proposals: 25
- Remote
- #2368159
- OPPORTUNITY
- Expired
+ 20 others have already sent a proposal.
Description
Experience Level: Expert
Our production server backs up our mysql db each night in the form of a number of .sql files (one for each table).
I want to import those .sql files to a local dev mac.
When I try to do this via MySQL Workbench it errors "UTF-8 Conversion ErrorOperation failed with exitcode 1".
I have also tried to do this using DBeaver - using one of the DBeaver import script options - this looked like it was doing something (progressed through all the tables over a period of about 10 minutes) but there are no tables to be found in the db (locally).
The production db's collation is character set is utf8 utf8_unicode_ci although the DB was created a long time ago and was originally Latin1_sweedish_ci so there is possibly an issue there.
I am looking for a MySQL expert to help me import the .sql files into my local machine (and if needed, to help me fix any Latin1 -> UTF8 issue).
I would like to work by screen share and voicecal - you can view my screen and tell me what to do.
Happy to work day or evening (GMT) as fits in well for you.
Thanks very much.
I want to import those .sql files to a local dev mac.
When I try to do this via MySQL Workbench it errors "UTF-8 Conversion ErrorOperation failed with exitcode 1".
I have also tried to do this using DBeaver - using one of the DBeaver import script options - this looked like it was doing something (progressed through all the tables over a period of about 10 minutes) but there are no tables to be found in the db (locally).
The production db's collation is character set is utf8 utf8_unicode_ci although the DB was created a long time ago and was originally Latin1_sweedish_ci so there is possibly an issue there.
I am looking for a MySQL expert to help me import the .sql files into my local machine (and if needed, to help me fix any Latin1 -> UTF8 issue).
I would like to work by screen share and voicecal - you can view my screen and tell me what to do.
Happy to work day or evening (GMT) as fits in well for you.
Thanks very much.
Nick W.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
50%
Last project
8 May 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Nick
What is the size?
793472
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies