Magento backup taking too longHow to do a SYSTEM rollback manuallyhow to fix database inconsistency for magento 1.7.0.2Magento Database item Export wamp mysqlAfter System Backup error Cannot login to adminlive site don't load when taking backupFatal error: Class 'Varien_Data_Collection_Filesystem' when taking backuphow to get wordpress data in fishpig magento integrationSave model bypassing active transactionmagento 1.9.1 database table mg_core_cache_tag went missingSystem Backup taking to long to run
How to avoid making self and former employee look bad when reporting on fixing former employee's work?
The unknown and unexplained in science fiction
Why is it wrong to *implement* myself a known, published, widely believed to be secure crypto algorithm?
Sprout Reports plugin - How to output a Matrix field into a row
My parents are Afghan
How can I test a shell script in a "safe environment" to avoid harm to my computer?
Add elements inside Array conditionally in JavaScript
Can a character shove an enemy who is already prone?
Magical Modulo Squares
Expl3 and recent xparse on overleaf: No expl3 loader detected
Gift for mentor after his thesis defense?
Align a table column at a specific symbol
Is it a good idea to copy a trader when investing?
get unsigned long long addition carry
What's an appropriate age to involve kids in life changing decisions?
Would the rotation of the starfield from a ring station be too disorienting?
99 coins into the sacks
Is it safe to keep the GPU on 100% utilization for a very long time?
Examples where existence is harder than evaluation
What are my options legally if NYC company is not paying salary?
Where do 5 or more U.S. counties meet in a single point?
What will Doctor Strange protect now?
Why is the episode called "The Last of the Starks"?
Creating Stored Procedure in local db that references tables in linked server
Magento backup taking too long
How to do a SYSTEM rollback manuallyhow to fix database inconsistency for magento 1.7.0.2Magento Database item Export wamp mysqlAfter System Backup error Cannot login to adminlive site don't load when taking backupFatal error: Class 'Varien_Data_Collection_Filesystem' when taking backuphow to get wordpress data in fishpig magento integrationSave model bypassing active transactionmagento 1.9.1 database table mg_core_cache_tag went missingSystem Backup taking to long to run
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
So, I decided to make a database backup from the magento admin panel. But it´s taking too long and there´s no way to know if the backup is actually working or if it got stucked.
Is there a way to stop the process without losing data? I can´t access to any other admin panel utility or make any purchase on my store.
database backup
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
add a comment |
So, I decided to make a database backup from the magento admin panel. But it´s taking too long and there´s no way to know if the backup is actually working or if it got stucked.
Is there a way to stop the process without losing data? I can´t access to any other admin panel utility or make any purchase on my store.
database backup
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
Do you want only backup of database? You can try sqlyog for database backup
– Jai
Jan 28 '18 at 23:46
add a comment |
So, I decided to make a database backup from the magento admin panel. But it´s taking too long and there´s no way to know if the backup is actually working or if it got stucked.
Is there a way to stop the process without losing data? I can´t access to any other admin panel utility or make any purchase on my store.
database backup
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
So, I decided to make a database backup from the magento admin panel. But it´s taking too long and there´s no way to know if the backup is actually working or if it got stucked.
Is there a way to stop the process without losing data? I can´t access to any other admin panel utility or make any purchase on my store.
database backup
database backup
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
asked Apr 12 '16 at 22:44
Gerry MillerGerry Miller
264
264
Do you want only backup of database? You can try sqlyog for database backup
– Jai
Jan 28 '18 at 23:46
add a comment |
Do you want only backup of database? You can try sqlyog for database backup
– Jai
Jan 28 '18 at 23:46
Do you want only backup of database? You can try sqlyog for database backup
– Jai
Jan 28 '18 at 23:46
Do you want only backup of database? You can try sqlyog for database backup
– Jai
Jan 28 '18 at 23:46
add a comment |
3 Answers
3
active
oldest
votes
You can take a backup by commands.
mysqldump -u username -p dbname > db_dump.sql
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
answered Oct 13 '16 at 17:13
touqeertouqeer
1
add a comment |
Yes Admin backup will take too long. Please check whether you selected maintenance mode while taking backup. If so go-to your root folder, and delete maintenance.flag file.
Sometimes the backup process will be running in the background, to kill that restart your webserver or if you know the pid of the backup process, you can kill that through ssh
In order to take backup from ssh use below command
mysqldump -u dbusername -p dbname > backupname.sql.
It will ask for password after entering this. Please note password is not visible while typing. Otherwise you can use this other version but not recommended.
mysqldump -u dbusername -pPassword dbname > backupname.sql.
You can immediately type password after -p option without any space as it is. I used capital P just for a notation.
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
add a comment |
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
Also, you can take backup in phpmyadmin by importing the Database.
If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
edited May 4 at 21:40
magefms
2,9662629
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f110599%2fmagento-backup-taking-too-long%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can take a backup by commands.
mysqldump -u username -p dbname > db_dump.sql
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
answered Oct 13 '16 at 17:13
touqeertouqeer
1
add a comment |
You can take a backup by commands.
mysqldump -u username -p dbname > db_dump.sql
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
answered Oct 13 '16 at 17:13
touqeertouqeer
1
add a comment |
You can take a backup by commands.
mysqldump -u username -p dbname > db_dump.sql
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
answered Oct 13 '16 at 17:13
touqeertouqeer
1
You can take a backup by commands.
mysqldump -u username -p dbname > db_dump.sql
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
answered Oct 13 '16 at 17:13
touqeertouqeer
1
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
edited Jan 28 '18 at 17:01
sv3n
10.1k62557
10.1k62557
answered Oct 13 '16 at 17:13
touqeertouqeer
1
answered Oct 13 '16 at 17:13
touqeertouqeer
1
answered Oct 13 '16 at 17:13
touqeertouqeer
1
1
add a comment |
add a comment |
Yes Admin backup will take too long. Please check whether you selected maintenance mode while taking backup. If so go-to your root folder, and delete maintenance.flag file.
Sometimes the backup process will be running in the background, to kill that restart your webserver or if you know the pid of the backup process, you can kill that through ssh
In order to take backup from ssh use below command
mysqldump -u dbusername -p dbname > backupname.sql.
It will ask for password after entering this. Please note password is not visible while typing. Otherwise you can use this other version but not recommended.
mysqldump -u dbusername -pPassword dbname > backupname.sql.
You can immediately type password after -p option without any space as it is. I used capital P just for a notation.
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
add a comment |
Yes Admin backup will take too long. Please check whether you selected maintenance mode while taking backup. If so go-to your root folder, and delete maintenance.flag file.
Sometimes the backup process will be running in the background, to kill that restart your webserver or if you know the pid of the backup process, you can kill that through ssh
In order to take backup from ssh use below command
mysqldump -u dbusername -p dbname > backupname.sql.
It will ask for password after entering this. Please note password is not visible while typing. Otherwise you can use this other version but not recommended.
mysqldump -u dbusername -pPassword dbname > backupname.sql.
You can immediately type password after -p option without any space as it is. I used capital P just for a notation.
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
add a comment |
Yes Admin backup will take too long. Please check whether you selected maintenance mode while taking backup. If so go-to your root folder, and delete maintenance.flag file.
Sometimes the backup process will be running in the background, to kill that restart your webserver or if you know the pid of the backup process, you can kill that through ssh
In order to take backup from ssh use below command
mysqldump -u dbusername -p dbname > backupname.sql.
It will ask for password after entering this. Please note password is not visible while typing. Otherwise you can use this other version but not recommended.
mysqldump -u dbusername -pPassword dbname > backupname.sql.
You can immediately type password after -p option without any space as it is. I used capital P just for a notation.
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
Yes Admin backup will take too long. Please check whether you selected maintenance mode while taking backup. If so go-to your root folder, and delete maintenance.flag file.
Sometimes the backup process will be running in the background, to kill that restart your webserver or if you know the pid of the backup process, you can kill that through ssh
In order to take backup from ssh use below command
mysqldump -u dbusername -p dbname > backupname.sql.
It will ask for password after entering this. Please note password is not visible while typing. Otherwise you can use this other version but not recommended.
mysqldump -u dbusername -pPassword dbname > backupname.sql.
You can immediately type password after -p option without any space as it is. I used capital P just for a notation.
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
edited Jan 28 '18 at 17:17
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi VKalyan Chakravarthi V
4621418
4621418
add a comment |
add a comment |
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
Also, you can take backup in phpmyadmin by importing the Database.
If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
edited May 4 at 21:40
magefms
2,9662629
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
add a comment |
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
Also, you can take backup in phpmyadmin by importing the Database.
If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
edited May 4 at 21:40
magefms
2,9662629
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
add a comment |
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
Also, you can take backup in phpmyadmin by importing the Database.
If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
edited May 4 at 21:40
magefms
2,9662629
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
Also, you can take backup in phpmyadmin by importing the Database.
If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
edited May 4 at 21:40
magefms
2,9662629
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
edited May 4 at 21:40
magefms
2,9662629
edited May 4 at 21:40
magefms
2,9662629
edited May 4 at 21:40
magefms
2,9662629
2,9662629
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
answered Apr 13 '16 at 5:12
Baby in MagentoBaby in Magento
8901355170
8901355170
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f110599%2fmagento-backup-taking-too-long%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Do you want only backup of database? You can try sqlyog for database backup
– Jai
Jan 28 '18 at 23:46