MySQL :: Mysqldump Can't Find Table

Mysqldump :: Bin/mysqldump: Got Error: 1: Can't Create/write To File
When executing the following command:

bin/mysqldump -u root -p -T /Users/bj/Desktop/ tfc

The following error appears:

bin/mysqldump: Got error: 1: Can't create/write to file '/Users/bj/Desktop/acts.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

However, it does write the 'acts.sql' file which one of the files in the tfc database.

I suspect this has something to do with permissions, but even when I run this as 'unix root user' I get the same error.

Posted: October 07, 2004 12:08PM

View 3 Replies! View Related

4.1 Mysqldump
is it possible?
if my just did a mysqldump of a 4.1 db and want to import it into a 4.0 db?

mysqldump --skip-opt --add-drop-table db_name > dump

but then when i went to the 4.0 and did a source dump, i got some syntax errors....

do i need a flag for backwards compat?

Posted: July 21st, 2006, 08:03 PM

View 2 Replies! View Related

MySqlDump For VB.NET
If I run mysqldump from a dos-window it works fine, but when I run exactly the same command from VB.NET it does NOT work.

The main problem is that I cann't see anything. I can see a window pop-up and close, but it is too fast for me to see anything on the window.

My command is:

mysqldump.exe klapper -u root -ppasword > c: empDumpKlapper.sql

What is wrong with the command and is there a way to keep the window open so I can see what error I get?

Posted: December 14th, 2008, 07:05 AM

View 3 Replies! View Related

Mysqldump &
I have done:
mysqldump -u root -p --all-databases > file.sql

which dumped arounf 80megs
now, I am struggling to import it back on another server
what shoudl i use mysqimport? what syntax?

Posted: January 28th, 2006, 06:46 AM

View 2 Replies! View Related

Mysqldump.
I am having trouble exporting the data using mysqldump. I have a test environment running on Windows XP. When I issue the command "mysqldump -h localhost -u root --password -d tbp", only the table definitions gets exported and not the actual data. Can anyone let me know what I could be doing wrong here?

Posted: February 16, 2005 12:17PM

View 2 Replies! View Related

How Do I Use Mysqldump?
mysqldump -A --allow-keywords --comments --compatible=mssql -ppcrm2006lp --result-file=pcrmsql --user=gdawson;

using MySQL Query. I got the standard error message. Then I tried just mysqldump; again, same error message. Then I went to the MySQL command line and tried again, first the command word alone and then the command with the parameters, both with the semicolon and without. Error every time. And always the same error message. I know I have done this before.

And once I get it to dump, how do I tell it where to dump to? I try and follow the manual. But it does not help.

Posted: June 17, 2008 08:22AM

View 18 Replies! View Related

Where Do You Run Mysqldump?
I always get a syntax error whenever doing mysqldump in my MySQL command line. So I was wandering if I am even meant to do it in the MySQL command line itself?

Do you run it in the MySQL command line or on the normal windows command line? Or somewhere else?

I use this syntax:

mysqldump -h localhost -u username -p password mydb > mydbbackup.sql

I'm sure my syntax is fine but I can't understand why I can't find anyone who has had this kind of problem.

Posted: Aug 22, 2006, 08:32

View 8 Replies! View Related

Mysqldump Blob
I have a databse with jpg in a blob field. I want to back it up with mysqldump, but it appears to time out. Is there a way to limit the number of records backed up (possibly with the where clause,) so that I can backup my big table in blocks?

Posted: July 19th, 2005 11:53 PM

View 3 Replies! View Related

5.0 Mysqldump-query
I upgraded to MySQL 5.0, but the remote server still runs 3.23. Before I upgraded I was able to, in a local DOS-prompt, execute a mysqldump and get the database from the server to a file on my computer. Now, when I execute the same query, the remote server does not understand my command.

This is what I execute on my local computer (simplified):
C:foldermysqldump --add-locks --add-drop-table -h xx.xx.xxx.xx -u username -p database > "C:folderdb_downloaded.sql"

This used to work, but after I upgraded I get the error message:
Couldn't execute '/*!40100 SET @@SQL_MODE='' */': Query was empty (1065)

Posted: March 2nd, 2006, 12:25 PM

View 1 Replies! View Related

Analysing MySQLDump
regular expression to extract the table names and the number of rows in each from the output of a SQL file produced by MySQLDump? I'm using this to verify from MySQLDump.

Posted: July 4th, 2005, 11:48 AM

View 1 Replies! View Related

Mysqldump Question
this is one about the results of a dump...basically nada. I entered:

/usr/local/bin/mysqldump -q -hMydb.some.com -uMyuser -pMypass

and got:

Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

whether to file or screen, no matter what options I enter. I don't get any error messages, e.g., connection problems.

Posted: December 15th, 2005, 03:58 PM

View 2 Replies! View Related

CRITICAL: Mysqldump
I am using version 4.1.10a and noticed a really big problem.

When I encryped sensitive data using AES_ENCRYPT and then performed a routine mysqldump for backup purposes, the resulting dump file does not preserve many of the encrypted characters properly.

AES_ENCRYPT is unusable if system admins cannot back up their tables reliably.

Posted: April 4th, 2005, 12:34 PM

View 9 Replies! View Related

Syntax For MySQLDump?
I have done some research into a mysql dump, but cant really figure out the syntax. If I have a table names dis, and with user name of root and password of password, what sort of string would I need?

Posted: December 15th, 2005, 06:32 AM

View 13 Replies! View Related

MYSQLDUMP :: In CSV Format
Im trying to export my table in csv formatt? I cant seem to get it to work im getting this error:
mysqldump: unknown option -s

i dont have a -s in my script heres my script:

mysqldump -u root -fields -terminated-by=,-tab= c: emp -tables ehpadmin direct_referral > new.txt

Posted: August 2nd, 2005, 10:46 AM

View 2 Replies! View Related

Mysqldump 1 Table
Is there any ways I can use mysqldump to actually dump all the data in a certain table?

Posted: May 24th, 2005, 11:02 PM

View 2 Replies! View Related

Mysqldump Shortcut
I'm trying to create a shortcut in windows xp which runs mysqldump to backup my online database to a file on my pc. I have used mysqldump via the command line to do this just fine but when i create a shortcut using exactly the same parameters it just doesnt work, i get a prompt come up asking for my password which is what i want, but after that it just disappears & nothing is downloaded
This is what i have in the shortcut 'target' box...

"C:Program FilesMySQLMySQL Server 5.0inmysqldump.exe" mysqldump -h hostname -u username -p databasename > "C:ackupmysqldb.dump"

Im having one of those 'why the **** doesnt this work?!?!' type moments so any help gratefully received.

Posted: December 22nd, 2006, 12:08 PM

View 2 Replies! View Related

Mysqldump Stops
I get mysqldump (fedora 3) work until it founds this error:
/usr/bin/mysqldump: Got error: 1033: Incorrect information in file: './mysql/help_category.frm' when using LOCK TABLES
This is first mysql database installed itself.
There are a lot of tables in mysql database that display the same error msg when I try to see their structure with phpMyAdmin.
How may I fix this?

Posted: April 29th, 2006, 02:18 PM

View 1 Replies! View Related

Mysqldump Utility
We have taken the Backup of MySQl database with version
mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686) Using mysqldump utility.

We tried to Restore the Same in another Linux System with mysql version mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i686) using readline 5.0 using the same mysqldump utily

It is giving Version mismatch error and unable to restore the Database. We also used --compatible=mysql40 Option but No change

Posted: January 17th, 2007, 12:31 AM

View 2 Replies! View Related

Mysqldump View
I try to dump the view definition and records using the following command.

mysqldump -uroot -psecret! --databases test --tables proxy_view > mytest.txt

What all I get is the view definition without records. What is the correct method of dumping a view?

Posted: February 1st, 2008, 02:55 AM

View 2 Replies! View Related

Query In Mysqldump
I need to do incremental-type backups ona mysql db. To this end I've been given a flag field to indicate whether the record's been backed up or not. If this is the best way or not is moot, this is how I've been told to do it. I was also told it's possible to specify which records to backup using a WHERE clause, but I can't find any info about doing such a thing.

My thought is that maybe I should use a query to create a temp table, backup THAT, and then drop it when I'm done.

Posted: August 17th, 2005, 08:43 PM

View 2 Replies! View Related

Mysqldump File
I know I knew how to do this, and I know that I found it somewhere in the manual, but it's Monday and I'm heading out so I thought I'd ask you all and hopefully have an answer when I get back on Tuesday so I can stop banging my head against the keyboard.
Recently set up mysql 4.0.20a on a development machine to try and upgrade to 4.1 before I blow up the live database and I make an hourly dump form the live database using mysqldump.I grabed the latest dump and moved it to the development machine but I can't for the life of me recall how to take that file and make it create all the database, tables, and data on the new install.
Any thoughts linkage to the right portion of the MySQL manual definatly acceptable
As an aside, did anyone else find the MySQL page to be extremely slow today (2/7/2005)

Posted: February 7th, 2005, 05:06 PM

View 3 Replies! View Related

Mysqldump To Backup
How do I use mysqldump to backup only one or two tables, not the whole database?

Posted: October 28th, 2005, 06:01 PM

View 4 Replies! View Related

Using The Mysqldump Command
I've been doing some research into creating a backup script for my PHP website. Using the mysqldump command looks like the best way to go. I am unsure on one thing though - where does it save the file to?

Like if I don't specify a path to the file, just something like 'dump.sql', then where will it save the file to? And how do I make it save to, for example, the root folder of a users website? My script may be on different websites so the path to the root folder of the website may change.

Posted: February 24th, 2005, 08:55 PM

View 6 Replies! View Related

Mysqldump Problem
I did a mysql dump of a database between two servers we have using the following command:

mysqldump --opt <db_name> -u <username> --password=<password> | mysql --host=<hostname> -C <db_name> -u <username> --password=<password>

This command seemed to run ok as it transferred all the structure and data from the original server to the new server database.

However, on closer inspection there is a problem. Many characters in the new database are showing up as a a question mark ? (e.g. characters such as ", trademark symbol, and fractions such as 1/3).

If I edit this data using phpmyadmin and replace it with the relevant symbol manually then it is ok.

There are hundreds of instances of these characters in the database and to change them manually would be very time consuming.

Is there and option regarding character sets I can set in the mysqldump that might solve this problem?

Posted: August 30, 2004 04:04AM

View 1 Replies! View Related