you can use "--ignore-table" option for this,
mysqldump -u -p dbname --ignore-table=dbname.tablename > xyz.sql
you can use this option multiple times to ignore multiple tables.
Rgds,
Jay
On Tue, Jan 18, 2011 at 6:18 PM, Adarsh Sharma wrote:
> Dear all,
>
>
> I am researching about diffe
Recently I went through a link related to this question. check the below
link.
I haven't checked the script, hope it will be useful.
http://tequilaphp.wordpress.com/2010/07/05/searching-strings-in-a-database-and-files/
Regards,
Jay
MySQL DBA
On Thu, Aug 12, 2010 at 2:31 AM, Carlos Mennens wrote:
Hi Carlos,
>From your trailing mail I noticed the below GRANT. This will just give
'cmennens'@'ideweb1.iamorlando.com' access to mysql but not any databases.
*Access to mysql:*
| GRANT USAGE ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' IDENTIFIED
BY PASSWORD '' |
In addition t
On Tue, Jul 20, 2010 at 9:58 PM, dennis skinner wrote:
>
>
> Hello I am a new mysql user. Can anyone tell me why this does not create
> a table?
>
> < ?php(the spaces before the question mark are not in the
> code)
> $dbuser="smeduser";
> $dbpassword="x";
> $dbname="smed";
> my
Hi Victor,
The actual problem is with the key field.
Flights.pilot_id is set to INT NOT NULL and you had specified Pilots.id to
INT NULL.
You have to change both the columns to NULL or else NOT NULL to avoid the
error.
Regards,
Jay
MySQL DBA
Datavail CORP
On Tue, Jun 22, 2010 at 7:45 PM, Victo
I got the below information from a website, when I encountered this error.
Hope this would be helpful for you.
In every case this is due to something about the relationship that MySQL
doesn’t like. Unfortunately it doesn’t specify what the exact issue is. Here
is a running list of causes that peo
