Mrthdrb

How to format long polynomial?

Replacing matching entries in one column of a file by another column from a different file

Either or Neither in sentence with another negative

Theorems that impeded progress

Prove that NP is closed under karp reduction?

Is it important to consider tone, melody, and musical form while writing a song?

Can a Warlock become Neutral Good?

"You are your self first supporter", a more proper way to say it

Collect Fourier series terms

Show that if two triangles built on parallel lines, with equal bases have the same perimeter only if they are congruent.

Voyeurism but not really

How to find program name(s) of an installed package?

Pattern match does not work in bash script

Watching something be written to a file live with tail

Is it unprofessional to ask if a job posting on GlassDoor is real?

What are these boxed doors outside store fronts in New York?

Why don't electron-positron collisions release infinite energy?

Do VLANs within a subnet need to have their own subnet for router on a stick?

What's the output of a record cartridge playing an out-of-speed record

tikz: show 0 at the axis origin

Minkowski space

Arthur Somervell: 1000 Exercises - Meaning of this notation

Why do falling prices hurt debtors?

Font hinting is lost in Chrome-like browsers (for some languages )

Mysqldump return empty file .sql

How can I prevent SQL injection in PHP?Run MySQLDump without Locking TablesHow do I restore a dump file from mysqldump?Skip certain tables with mysqldumpImport SQL dump into PostgreSQL databasemysqldump of all databases on Windows 7 with PHPmysqldump from inside phpTroubleshooting mysqldump via PHPmysqldump not producing any outputMySqlDump - Empty dump by using Windows

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I'm try to do a dump of my db in this way:

$output = NULL;
$command = 'mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql';
passthru($command, $output);

I've tried in this way too:

$command = 'mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql';
exec($command);

In both ways it create an empty dump.sql

Where am I wrong? Can you help me?

php database

share|improve this question

asked Apr 3 at 14:57

MastafisMastafis

1

migrated from magento.stackexchange.com Apr 3 at 15:03

This question came from our site for users of the Magento e-Commerce platform.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  If you echo/log that $command and run it from the command line, does it work for you?
  
  – aynber
  Apr 3 at 15:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  emvee-solutions.com/blog/…
  
  – Ronak Rathod
  Apr 3 at 15:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RonakRathod thank you. Is there a way to import by magento function this dump?
  
  – Mastafis
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Most Welcome @Mastafis
  
  – Ronak Rathod
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RonakRathod Is there a way to import by magento function this dump?
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

0

I'm try to do a dump of my db in this way:

$output = NULL;
$command = 'mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql';
passthru($command, $output);

I've tried in this way too:

$command = 'mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql';
exec($command);

In both ways it create an empty dump.sql

Where am I wrong? Can you help me?

php database

share|improve this question

asked Apr 3 at 14:57

MastafisMastafis

1

migrated from magento.stackexchange.com Apr 3 at 15:03

This question came from our site for users of the Magento e-Commerce platform.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  If you echo/log that $command and run it from the command line, does it work for you?
  
  – aynber
  Apr 3 at 15:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  emvee-solutions.com/blog/…
  
  – Ronak Rathod
  Apr 3 at 15:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RonakRathod thank you. Is there a way to import by magento function this dump?
  
  – Mastafis
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Most Welcome @Mastafis
  
  – Ronak Rathod
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RonakRathod Is there a way to import by magento function this dump?
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

I'm try to do a dump of my db in this way:

$output = NULL;
$command = 'mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql';
passthru($command, $output);

I've tried in this way too:

$command = 'mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql';
exec($command);

In both ways it create an empty dump.sql

Where am I wrong? Can you help me?

php database

share|improve this question

asked Apr 3 at 14:57

MastafisMastafis

1

$command = 'mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql';
exec($command);

share|improve this question

asked Apr 3 at 14:57

MastafisMastafis

1

share|improve this question

asked Apr 3 at 14:57

MastafisMastafis

1

asked Apr 3 at 14:57

MastafisMastafis

1

asked Apr 3 at 14:57

MastafisMastafis

1

2 Answers
2

active

oldest

votes

2

I would suggest you to make use of the --single-transaction flag while using mysqldump.

mysqldump --single-transaction -u$dbuser -hlocalhost -p$password $dbname > dump.sql

With that said, I would suspect either a timeout (PHP or MySQL) or a out-of-memory error.

How did you executed your script? Browser or CLI?

share|improve this answer

answered Apr 3 at 15:07

MACIMACI

212

New contributor

MACI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've tried with your command by CLI but it sees a password character (@) as a separator and then returns an error on the command.
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

1

I can not say exactly but if you are using single quotes, php variables wont be replaced with real values. You should use double quotes instead of single quotes.

Like $command="mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql";

Try to print command before execute to make sure that values are replaced with variables.

Let me know if that doesnt work, will give u an option to debug more accurately.

share|improve this answer

answered Apr 3 at 17:07

Yash ShahYash Shah

1744

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, i've tried to echo it and it's correct.
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f55498362%2fmysqldump-return-empty-file-sql%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

I would suggest you to make use of the --single-transaction flag while using mysqldump.

mysqldump --single-transaction -u$dbuser -hlocalhost -p$password $dbname > dump.sql

With that said, I would suspect either a timeout (PHP or MySQL) or a out-of-memory error.

How did you executed your script? Browser or CLI?

share|improve this answer

answered Apr 3 at 15:07

MACIMACI

212

New contributor

MACI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've tried with your command by CLI but it sees a password character (@) as a separator and then returns an error on the command.
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

2

I would suggest you to make use of the --single-transaction flag while using mysqldump.

mysqldump --single-transaction -u$dbuser -hlocalhost -p$password $dbname > dump.sql

With that said, I would suspect either a timeout (PHP or MySQL) or a out-of-memory error.

How did you executed your script? Browser or CLI?

share|improve this answer

answered Apr 3 at 15:07

MACIMACI

212

New contributor

MACI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've tried with your command by CLI but it sees a password character (@) as a separator and then returns an error on the command.
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

I would suggest you to make use of the --single-transaction flag while using mysqldump.

mysqldump --single-transaction -u$dbuser -hlocalhost -p$password $dbname > dump.sql

With that said, I would suspect either a timeout (PHP or MySQL) or a out-of-memory error.

How did you executed your script? Browser or CLI?

share|improve this answer

answered Apr 3 at 15:07

MACIMACI

212

New contributor

MACI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

mysqldump --single-transaction -u$dbuser -hlocalhost -p$password $dbname > dump.sql

share|improve this answer

answered Apr 3 at 15:07

MACIMACI

212

New contributor

MACI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered Apr 3 at 15:07

MACIMACI

212

New contributor

MACI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered Apr 3 at 15:07

MACIMACI

212

1

I can not say exactly but if you are using single quotes, php variables wont be replaced with real values. You should use double quotes instead of single quotes.

Like $command="mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql";

Try to print command before execute to make sure that values are replaced with variables.

Let me know if that doesnt work, will give u an option to debug more accurately.

share|improve this answer

answered Apr 3 at 17:07

Yash ShahYash Shah

1744

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, i've tried to echo it and it's correct.
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

1

I can not say exactly but if you are using single quotes, php variables wont be replaced with real values. You should use double quotes instead of single quotes.

Like $command="mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql";

Try to print command before execute to make sure that values are replaced with variables.

Let me know if that doesnt work, will give u an option to debug more accurately.

share|improve this answer

answered Apr 3 at 17:07

Yash ShahYash Shah

1744

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi, i've tried to echo it and it's correct.
  
  – Mastafis
  yesterday
  

  
  
  
  

add a comment | 

I can not say exactly but if you are using single quotes, php variables wont be replaced with real values. You should use double quotes instead of single quotes.

Like $command="mysqldump -u $dbuser -h localhost -p$password $dbname > dump.sql";

Try to print command before execute to make sure that values are replaced with variables.

Let me know if that doesnt work, will give u an option to debug more accurately.

share|improve this answer

answered Apr 3 at 17:07

Yash ShahYash Shah

1744

share|improve this answer

answered Apr 3 at 17:07

Yash ShahYash Shah

1744

answered Apr 3 at 17:07

Yash ShahYash Shah

1744

answered Apr 3 at 17:07

Yash ShahYash Shah

1744