All Questions
Tagged with database importexport
29 questions
0
votes
1
answer
362
views
Import Order from Magento 1 to Magento 2
I need to import orders from m1 to m2 and available orders in m1 are a minimum of 2 lakh on the m1 website. So I thought we were going with SQL and importing orders using SQL.
if anyone has created an ...
- 1,009
2
votes
2
answers
663
views
Magento 2 Slow import when 900 attribute options
We have a store with 35000 sku and there are 950 attribute options -
We find that when making any updates to products like price or qty or any other changes it is very very slow - like 5 mins if ...
- 43
0
votes
1
answer
351
views
how to migrate order , customer data mysql from one environment to another
need table detail which we need export order , customer attribute from same version of magneto but different server
need table name .
any admin import /export method.
- 40
0
votes
2
answers
148
views
delete export record from which table?
for some reason, I have to delete this record from the table, (it is stuck, cannot download or delete)
anyone know this record belongs to which table? so I can delete it by sql query
Thanks
- 658
1
vote
2
answers
2k
views
MySQL Query for an export of all products?
Is there any way to find out a MySQL query that would give the same results as exporting all shop products?
The reason I need this. When trying to export, I get the error
Message is added to ...
- 13
3
votes
1
answer
4k
views
How to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?
What is the best way to manually move the orders and customers to Magento 2.2.6 from Magento 1.8.1 without any third part extensions? there are around 100 records only.
I was able to migrated all ...
- 990
0
votes
1
answer
81
views
Magento product export import not working?
So I exported all my products by using the magento exporter under
System -> Import-Export -> Dataflow Profile -> Export all products
and then on the other magento installation:
System -&...
- 3,431
1
vote
1
answer
31
views
How to change base_url of other stores?
I exported a live database from a magento installation with 2 websites and 3 different stores and imported it on another magento installation.
I already changed the base_url of the main store, but ...
- 3,431
1
vote
1
answer
144
views
Magento in maintenance mode after importing database from live to test
I created a dump of my live database and imported it into staging by using n98-magerun.
./n98-magerun.phar db:import live.sql
But now my website is in maintenance mode, even though there is no ...
- 3,431
0
votes
0
answers
21
views
I have 10,271 attributes in a database I want to add them to magento 1
I have 10,271 attributes in a database I want to add them to magento 1 (inside an attribute group name "specification"), then import all the attribute values in each of the previous attribute fields. (...
- 111
1
vote
3
answers
9k
views
How Exporting PhpMyAdmin data in Zipped or gzipped
I am a learner with Magento i have created dummy website on my localhost Xmapp server. Now i want to move it to live server but when i am exporting Mysql data base it is directly downloaded in sql and ...
- 21
2
votes
1
answer
220
views
password_hash convert into simple md5 format
How to export all customers in simple username , email, and simple md5 format csv.
- 51
1
vote
2
answers
4k
views
Export a csv with product name and thumbnail image?
I know it's possible to export csv's from Magento. Is there a way to get a small image to export in a column and not just the image path or url.
Also, I know _media_image is a field, is that an ...
- 11
0
votes
1
answer
394
views
SQLSTATE[HY000] [2006] MySQL server has gone away after "Run import"
we are using magmi_full_0.7.19a
we tried "Run Import" , we are getting following error.
SQLSTATE[HY000] [2006] MySQL server has gone away -
is it related to server issue . how to fix this ?
- 2,975
0
votes
1
answer
46
views
Joomla - VirtueMart 1.x > Magento 2.0
I got a project where a client who is running a relatively big e-commerce is planing to switch from Joomla's VirtueMart 1.1 to Magento 2.0.
What is the best way to export products/customers/...
- 183
0
votes
1
answer
70
views
Magento Database import to new Database
trying to dump my cms_block and cms_page tables to new working Database. I get the Duplicate Entry for Primary Key ...what is the best way to go about this? when I export tables from old db I have ...
- 551
0
votes
1
answer
55
views
Magento import the live site database?
I am wanted to import the live site in the local environment. i have installed the magento on the localhost now which steps i have to follow for the successful import of the live db in the local ...
- 205
2
votes
2
answers
2k
views
Keeping files in one server and media files in another server
we have a magento site with thousands of products. it will grow for millions
so we are worrying about performance of the server.
we are planning to put media folder [ images ] in one server and ...
user33510
0
votes
1
answer
434
views
Truncating old log tables giving error
we bought magento extension for uploading the products through excel sheet.
we are uploading Products using csv file. now uploading speed is too much less.
I am trying this query to increase upload ...
user33510
1
vote
1
answer
160
views
Add index for import
To speed up the import process we added the index:
ALTER TABLE catalog_product_entity_varchar
ADD INDEX IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_VALUE (value ASC);
After these changes the "search product" ...
- 6,104
2
votes
0
answers
2k
views
How to Move Products, Attributes, Images, and Customers From One Magento Installation to Another
I have Magento 1.9.2.1 installed and I also installed a test Magento installation in a subdomain. Basically, the theme I have installed on my current Magento installation was designed for an older ...
- 309
1
vote
2
answers
2k
views
magento database file not importing completely
we are trying to move the magento site from one domain to another domain.
but the database filoe size is 800mb.
we are using cpanel.
when we are trying to import the database, its not uploading ...
- 2,975
2
votes
2
answers
963
views
database import error
i have imported my local magento database to live one with phpmyadmin. but when im trying to access my web site i get this error log.
a:4:{i:0;s:63:"Item (Mage_Core_Model_Store) with the same id "0" ...
- 859
0
votes
2
answers
3k
views
Only the Homepage is showing after moving Magento
I've just moved a Magento website to another server and domain.
I adjusted the secure and unsecure url path in the cofig data table and also adjusted the config.xml. After that i've also cleared the ...
- 3
1
vote
1
answer
37
views
Migrate local server database info to remote web server after adding language or storefront
I have a Magento local install for testing. How do I transfer my database changes after I add e.g. a new language.
I have added all the products texts etc pp, but I can't just dump the mysql database ...
- 11
1
vote
1
answer
475
views
magento Cannot add or update a child row when import database
I tried to move Magento site from sub-doamin into new main domain.
when I tried to import a database, I got following error :
"Magento Cannot add or update a child row: a foreign key constraint ...
- 2,975
4
votes
3
answers
4k
views
Exporting admin panel settings that are saved to the database
When handling different environments for dev and live sites, how to pass on changes that are only saved to the database to the other environment without having to export the whole database? Say for ...
- 1,424
1
vote
1
answer
1k
views
how to export/import websites,stores,store-views?
I have a Magento install with 58 websites, and i need to recreate them in a new installation. Is there any way to export the database table which handle this?, and then import it in the new DB?.
...
- 307
0
votes
2
answers
1k
views
Getting product information from a external database
I have been given an unfinished product from a client, and it is a mess.
This is my first time ever using Magento, but I have used other CMS's. So please bare with me as I am a "newbie". I do have ...
- 1