Backup MySQL Database

[ideasgirl]

Thank you very much. That solved it.

[ideasgirl]

Hi,

Lately I'm getting the following warning when doing backups:

Warning: Using a password on the command line interface can be insecure.

Zen Cart v.1.5.4
PHP Version: 5.6.30
Database: MySQL 5.6.35

Is there a way to solve this?

Was this ever fixed? I still getting it.

[DrByte]

Hi,

Lately I'm getting the following warning when doing backups:

Warning: Using a password on the command line interface can be insecure.

Zen Cart v.1.5.4
PHP Version: 5.6.30
Database: MySQL 5.6.35

Is there a way to solve this?

Was this ever fixed? I still getting it.

It's a legitimate warning.
It's harmless.
There are no plans to try to "hide" it, lest such plans mistakenly suppress other messages that could actually be important to see.

[NWCE]

Hi,

I am in the process of upgrading my site to v1.5.7c and have installed it in my local computer to work on it before taking it live. I have installed the backup_mysql_plugin_v5g. I have backed up my database (quite large) from my current live site (running v 1.5.5e) I use the Restore function on my local copy, it seems to run (I get no errors) but here is what is in the logs

[01-Apr-2021 22:14:25 UTC] PHP Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in C:\wamp64\www\store\admin\backup_mysql.php on line 519
[01-Apr-2021 22:14:25 UTC] PHP Stack trace:
[01-Apr-2021 22:14:25 UTC] PHP 1. {main}() C:\wamp64\www\store\admin\index.php:0

and no information is imported. I am doing something wrong?

I have also tried to import the database through the MySql console in Wamp and it runs its sequence, gives no errors, and when it is completed, no information is updated.

If someone could shed some light on this I would appreciate it!

Thanks,

Jeff

[swguy]

Check your database export and see if it specifies the live site name - perhaps the database was created but with that name instead of the local name you expected?

[swguy]

(You would see something like "USING live-site-database-name" at the top of the file if this is what is happening.)

[NWCE]

Thanks for your reply SWGuy!

I do not see this error anywhere, but will check the old database I am trying to import to see if I can see this suggestion.

[NWCE]

I have checked the database and don't see this "USING live-site-database-name" as you had mentioned.

I do see this:

Host: localhost Database: "current database name"

So that should rule out that potential problem. Anything else to check??? In looking at the database info, it is all there when I open the saved database that I have backed up from my current site......just to rule out any possibility that the info corrupted during downloading it to my local computer.

[swguy]

I have never done a restore through this tool - can you just do it on the command line? Sorry, I don't know how to do it in Windows; in Linux it would be

mysql -uUSER -pPASS dbname < database_dump.sql

[NWCE]

Thanks again for your reply SWGuy.....

Yes, I did try to import using the command line through MySql console in Wamp. It gives me the command line....I change to the specific database I want to import into and then use the Source command and the path to the database file.

When I have done this, it runs it sequence, no errors and when it is complete, none of the information has imported. Don't know why???

Any thoughts on doing it this way.....again, have I missed something?

Thanks again,

Jeff