Ttdfjt

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;

3

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

share|improve this question

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 | 

3

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

share|improve this question

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

share|improve this question

asked Apr 12 '16 at 22:44

Gerry MillerGerry Miller

264

share|improve this question

asked Apr 12 '16 at 22:44

Gerry MillerGerry Miller

264

share|improve this question

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

3 Answers
3

active

oldest

votes

0

You can take a backup by commands.

mysqldump -u username -p dbname > db_dump.sql

share|improve this answer

edited Jan 28 '18 at 17:01

sv3n

10.1k62557

answered Oct 13 '16 at 17:13

touqeertouqeer

1

add a comment | 

0

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.

share|improve this answer

edited Jan 28 '18 at 17:17

answered Jan 28 '18 at 3:52

Kalyan Chakravarthi VKalyan Chakravarthi V

4621418

add a comment | 

0

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

   
   

   
   

share|improve this answer

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
);



);

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

0

You can take a backup by commands.

mysqldump -u username -p dbname > db_dump.sql

share|improve this answer

edited Jan 28 '18 at 17:01

sv3n

10.1k62557

answered Oct 13 '16 at 17:13

touqeertouqeer

1

add a comment | 

0

You can take a backup by commands.

mysqldump -u username -p dbname > db_dump.sql

share|improve this answer

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

share|improve this answer

edited Jan 28 '18 at 17:01

sv3n

10.1k62557

answered Oct 13 '16 at 17:13

touqeertouqeer

1

mysqldump -u username -p dbname > db_dump.sql

share|improve this answer

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

answered Oct 13 '16 at 17:13

touqeertouqeer

1

answered Oct 13 '16 at 17:13

touqeertouqeer

1

0

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.

share|improve this answer

edited Jan 28 '18 at 17:17

answered Jan 28 '18 at 3:52

Kalyan Chakravarthi VKalyan Chakravarthi V

4621418

add a comment | 

0

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.

share|improve this answer

edited Jan 28 '18 at 17:17

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.

share|improve this answer

edited Jan 28 '18 at 17:17

answered Jan 28 '18 at 3:52

Kalyan Chakravarthi VKalyan Chakravarthi V

4621418

mysqldump -u dbusername -p dbname > backupname.sql.

mysqldump -u dbusername -pPassword dbname > backupname.sql.

share|improve this answer

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

0

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

   
   

   
   

share|improve this answer

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 | 

0

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

   
   

   
   

share|improve this answer

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.

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

   
   

   
   

share|improve this answer

edited May 4 at 21:40

magefms

2,9662629

answered Apr 13 '16 at 5:12

Baby in MagentoBaby in Magento

8901355170

share|improve this answer

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

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