Magento backup taking too long
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 Miller
264
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
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 Miller
264
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
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 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 Miller
264
asked Apr 12 '16 at 22:44
Gerry Miller
264
asked Apr 12 '16 at 22:44
Gerry Miller
264
asked Apr 12 '16 at 22:44
Gerry Miller
264
asked Apr 12 '16 at 22:44
Gerry Miller
264
264
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
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
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
1)Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
2)Also you can take backup in phpmyadmin by importing the Database.
3)If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
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
9,64062352
answered Oct 13 '16 at 17:13
touqeer
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 V
4051418
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
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
1)Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
2)Also you can take backup in phpmyadmin by importing the Database.
3)If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
add a comment |
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
1)Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
2)Also you can take backup in phpmyadmin by importing the Database.
3)If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
add a comment |
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
1)Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
2)Also you can take backup in phpmyadmin by importing the Database.
3)If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
Backup time depends on how many products & customers you have.
You can truncate all log data in your database.
1)Instead of Manual backup , you can take backup at night time by setting scheduled backup
System > Configuration > Advanced > system> Scheduled backup setttings
2)Also you can take backup in phpmyadmin by importing the Database.
3)If you have ssh access, you can take backup by commands.
mysql -uUSER -p -hHOST DB_NAME < db_dump.sql
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
edited Apr 13 '16 at 5:17
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
answered Apr 13 '16 at 5:12
Baby in Magento
8311352164
8311352164
add a comment |
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
9,64062352
answered Oct 13 '16 at 17:13
touqeer
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
9,64062352
answered Oct 13 '16 at 17:13
touqeer
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
9,64062352
answered Oct 13 '16 at 17:13
touqeer
1
You can take a backup by commands.
mysqldump -u username -p dbname > db_dump.sql
edited Jan 28 '18 at 17:01
sv3n
9,64062352
answered Oct 13 '16 at 17:13
touqeer
1
edited Jan 28 '18 at 17:01
sv3n
9,64062352
edited Jan 28 '18 at 17:01
sv3n
9,64062352
edited Jan 28 '18 at 17:01
sv3n
9,64062352
9,64062352
answered Oct 13 '16 at 17:13
touqeer
1
answered Oct 13 '16 at 17:13
touqeer
1
answered Oct 13 '16 at 17:13
touqeer
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 V
4051418
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 V
4051418
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 V
4051418
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 V
4051418
edited Jan 28 '18 at 17:17
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi V
4051418
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi V
4051418
answered Jan 28 '18 at 3:52
Kalyan Chakravarthi V
4051418
4051418
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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