Helza wrote:
>
> Hi,
>
> I've made an backup of my MySQL db using:
>
> mysqldump -uoperatio_operati -p***** operatio_forum >> database.sql
>
> and with:
> mysqldump -uoperatio_operati -p***** --quick --add-drop-table --add-locks
>--extended-insert --lock-tables operatio_forum > database.sql
>
> both produce a mysql back of around 2-3 mb...
>
> however when i try to import it with:
>
> mysqldump -uoperatio_operati -p***** operatio_forum < database.sql
>
> nothing happens.. i just see:
>
> # MySQL dump 8.12
> #
> # Host: localhost Database: operatio_forum
> #--------------------------------------------------------
> # Server version 3.23.32
>
> nothing else..
> and nothing is imported into the MySQL db :((
>
> PLEASE help me as i need to have a working backup :(
>
> Greetings Helza
Hi,
Don't use mysqldump to restore, use mysql instead:
mysql -uoperatio_operati -p***** operatio_forum < database.sql
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
