Search DaniWeb - mysqldump

Re: mysqldump 14 Years Ago by verruckt24 …what you could do is before starting with the mysqldump, create a table identical to the original one …%tablename%... AS SELECT * from %originaltablename%' syntax then run mysqldump on this table and then finally drop the duplicate table… could use explicit locking on tables during the mysqldump and truncate commands and release them only after the… Re: mysqldump 16 Years Ago by MitkOK …] > [backupfile.sql]";[/code] Restore : [code=php]$command = "mysqldump -u [username] -p [password] [databasename] < [backupfile.sql]";[/code… mysqldump 16 Years Ago by cancer10 Hi Does anyone know what is the simplest way to backup a database using the [b]mysqldump[/b] function in php? I have googled a lot and the codes i have found are very hard to understand and most of them does not work. Thanx in advance for your help. Re: mysqldump 16 Years Ago by stymiee If you are allowed to use exec() then that will make it a one line script. Otherwise you can't access mysqldump directly through PHP. Re: mysqldump 16 Years Ago by MitkOK [QUOTE=stymiee;402729]If you are allowed to use exec() then that will make it a one line script. Otherwise you can't access mysqldump directly through PHP.[/QUOTE] ... or system() :cool: Re: mysqldump 16 Years Ago by pritaeas Mitko, the restore command should be using mysql, not mysqldump. mysqldump 14 Years Ago by andrei4002 … ones added during the dump) i know i can set mysqldump to lock the tables, but after the dump ends it… mysqldump downgrade 5 Years Ago by davy_yg … mysql bench to sql file I am getting this error: mysqldump.exe is version 8.0.13 but the MySQL Server… dumped has version 5.7.21. Because the version of mysqldump is not the same as the server, some features may… you upgrade or downgrade your local MySQL client programs, including mysqldump, to a version equal to or newer than that of… Re: mysqldump help with options 12 Years Ago by wolf29 …tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret >…had the options messed up. [CODE]Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 … removed the space between -p and the password. [CODE]mysqldump -v -u root -p--secret-- --all-databases >… mysqldump help with options 12 Years Ago by wolf29 … databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2… me I had the options messed up. [CODE]Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR… Mysqldump can't connect to localhost (Error 2003 & 10049) 11 Years Ago by savedlema … with VB.NET). The problem is I can't get mysqldump to backup the database. I'm using the following code…) "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe", "--user=root --password =mypassword" "--host… host) When I run that, I get the error: "mysqldump: Got error: 2003: Can't connect to MySQL server on… Re: Mysqldump can't connect to localhost (Error 2003 & 10049) 11 Years Ago by savedlema …: "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe", "--user=root --password =mypassword" "--host…;" But now I get a different error message:"Mysqldump: Got error:1044:Access denied for user ''@'localhost' to database… Re: Mysqldump can't connect to localhost (Error 2003 & 10049) 11 Years Ago by pritaeas Try this: "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" --user=root --password=mypassword --host=localhost --port=3301 --databases databasename > "C:\GreatestHR Backup\BackUpDataBase.sql" Read more in [the manual](http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html). mysqldump to c# 14 Years Ago by ryn6 hi all i know that to be able to bakckup with mysqldump i need to type mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] i was just wondering how can i pass that command from a windows app using c# Re: mysqldump to c# 14 Years Ago by ryn6 …;); startInfo.WindowStyle = ProcessWindowStyle.Minimized; Process.Start(startInfo); startInfo.Arguments = "mysqldump -u admin -p admin test > c:\backupfile.sql"… mysqldump from asp 18 Years Ago by william_stam i need to run a backup script for a mysql database how do i run "mysqldump" from asp? ive tried aspexec and mcs but no luck. am i missing something? basicaly i need to be able to backup a database at a click of a button in an asp application. thanks in advance mysqldump -p problems 16 Years Ago by knighth001 … the following command: #!/bin/sh date=`date '+%y-%m-%d'` mysqldump -u root -pmy_pwd -p -C -Q -e -a moodle >… mysqldump - new version? 16 Years Ago by trudge … now have to figure out the proper arguments to call mysqldump with, or should I use alternative methods to get a… mysqldump with insert set syntax 13 Years Ago by blocblue … new database. What I want to do is create a mysqldump, which uses the following syntax, so that values are matched… mysqldump in php 13 Years Ago by iamfrank … it work. So I know I can do : $command = "mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]"; then… Re: mysqldump in php 13 Years Ago by sops21 … that backup... Create a file called backup [CODE] #!/bin/sh mysqldump -uusername -ppassword --opt tablename > /path/tofile/location/youwant/mysqldumpfile… Re: Not able to restore sql file throufh mysqldump 11 Years Ago by pritaeas `mysqldump` creates an sql file. If you wish to import it again you'll need to use `mysql` Re: mysqldump 16 Years Ago by cancer10 and how about restoring the db? Re: mysqldump 16 Years Ago by stymiee [QUOTE=cancer10;402732]and how about restoring the db?[/QUOTE] [url]http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/2/[/url] [QUOTE=MitkOK;402739]... or system() :cool:[/QUOTE] :) Re: mysqldump 16 Years Ago by atplerry this is nice one a really learn from it Re: mysqldump 16 Years Ago by MitkOK Pritaeas, you are rigth. My bad. -[COLOR="Green"][B][I] Mitko Kostov[/I][/B][/COLOR] Re: mysqldump 14 Years Ago by pritaeas If you are using a different user for the dump, than you could disallow priviliges to the general user, while dumping/truncating, and reset priviliges afterwards. "FLUSH TABLES WITH READ LOCK" may be a better option. But haven't used it myself. using MySqlDump 12 Years Ago by dennysimon hello all how to use mysqldump in my project I see an example : MySqlDump my_dump=new MySqlDump(); but it seem need some reference or something,and won't work without it what should I add to make it give no error' thank you denny Re: using MySqlDump 12 Years Ago by thines01 If you're using the ADO classes, you'll never need anything like this. The only thing I've seen on MysqlDump is a reference to a command-line tool for backking up the database. [url]http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html[/url] Trouble restoring database backed with mysqldump 11 Years Ago by savedlema … trouble restoring a mysql database that I backed up with mysqldump. I have been trying to do this from a command… could told me why changing > to < in the mysqldump command does not work 100% in restoring the backed database)