I have advanced this Script but I don't know why it doesn't work for me I can't locate the error if someone can help me?
@echo off
mysqldump -h localhost -u root -p Dotado256 sixstar_almacen > AlmacenBeta _ 19082018.sql
Pause
I use Xammp the database is (sixstar_almacen) Obviously without parentheses, what I want is that when I click this Bat I do the .SQL on my PC but it doesn't work
In short notation: (check the spaces well)
Extended Notation (
--result-file
it is so that windows does not save the file in UTF-16 or replace them\n
with\r\n
)localhost
You may have to change127.0.0.1
if the user permissions are by ip and not by wildcard.If the output file includes spaces put it in double quotes:
Xampp usually installs the mysql binaries in
So an example with that route would be:
the sql file will be saved where the batch is executed (if it is the desktop it will be left there) so you can also put the full path to the wave file:
"C:\AlmacenBeta_19082018.sql"
.SET
in a command lineCMD
to see if it comes out) you can put"%USERPROFILE%\Documents\AlmacenBeta_19082018.sql"
it to save it in the documents folder of your user (Documents
it can beMis Documentos
in Spanish versions but I think there is a symlink that takes it the same )