[LRUG] mysqldump not working

[Riccardo Tacconi]

On Wed, Feb 3, 2010 at 3:34 PM, Riccardo Tacconi <rtacconi at gmail.com> wrote:

> This is the output when trying to dump the file inside an new fresh db:
>
> -bash-3.00$ mysqldump -uriccardot -p intranet_dump < intranet2.sql
> Enter password:
> -- MySQL dump 10.10
> --
> -- Host: localhost    Database: intranet_dump
> -- ------------------------------------------------------
> -- Server version       5.0.19-log
>
> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> /*!40101 SET NAMES utf8 */;
> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
> /*!40103 SET TIME_ZONE='+00:00' */;
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
>
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
> /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
> /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
>
> Alex, I tried to remove some part of the script that I thought they could
> create an error, but I have no clue. I do not have any feedback from
> mysqladmin. Then I am so angry to today that I cannot think properly, I
> should take some days of holidays :-(
>
>
>
not mysqladmin but mysqldump sorry


>
>
>
> On Wed, Feb 3, 2010 at 12:48 PM, Alex Young <alex at blackkettle.org> wrote:
>
>> Riccardo Tacconi wrote:
>>
>>> Hi,
>>>
>>> I know that this is not a MySql user group, but it should be the most
>>> used DBMS with Rails and Ruby. I asked a question in Stackoverflow.com:
>>> http://stackoverflow.com/questions/2191200/mysqldump-not-restoring-data-in-mysql-5-0-19
>>>
>>
>> It's difficult to analyse something like this without seeing the precise
>> setup. Have you tried isolating the problem to the minimum schema that will
>> show the fault? If you could post a short mysqldump output that shows the
>> problem, you might get more responses. If you can't set up a new database to
>> demonstrate it, chop out anything irrelevant from your current dump and
>> substitute any confidential data.
>>
>> I have seen similar problems in the past. From memory they were to do with
>> privileges being tied to the host IP address, but I seem to recall that gave
>> a specific error rather than failing silently.
>>
>> --
>> Alex
>>
>> _______________________________________________
>> Chat mailing list
>> Chat at lists.lrug.org
>> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>>
>
>
>
> --
> Riccardo Tacconi
> Web developer at Wolseley UK
> VIRTUELOGIC LIMITED (Director)
>
> http://www.linkedin.com/in/riccardotacconi
> http://riccardotacconi.blogspot.com/
> http://twitter.com/rtacconi
> Linux user: #400461
>



-- 
Riccardo Tacconi
Web developer at Wolseley UK
VIRTUELOGIC LIMITED (Director)

http://www.linkedin.com/in/riccardotacconi
http://riccardotacconi.blogspot.com/
http://twitter.com/rtacconi
Linux user: #400461
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20100203/5c5942d9/attachment.html>