Hi,
Miguel Cardenas wrote:
Remember to quote the user and host carefully. So,
The quoting is okay, I tested again
If you have doubts about what you actually granted, do this:
SHOW GRANTS FOR 'user'
I've sent this command:
grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass';
You are still missing the GRANT for 'myuser'@'localhost'
On Mon, May 21, 2007 03:06, Miguel Cardenas wrote:
>> Remember to quote the user and host carefully. So,
>
> The quoting is okay, I tested again
>
>> If you have doubts about what you actually granted, do this:
>> SHOW GRANTS FOR 'user'
>
>
Have you tried using the
> use db
> source /path/to/dumpfile.sql
command via the mysql command line client?
At 08:28 AM 5/20/2007, Vitaliy Okulov wrote:
Çäðàâñòâóéòå, mysql.
How i can speedup restore of mysql DB from file created by mysqldump?
MySQL is quite fast at reloading data, but if
At 08:28 AM 5/20/2007, Vitaliy Okulov wrote:
Çäðàâñòâóéòå, mysql.
How i can speedup restore of mysql DB from file created by mysqldump?
MySQL is quite fast at reloading data, but if you don't have enough memory
or if key_buffer_size is not set high enough, then it can take days to
re-index t
> Remember to quote the user and host carefully. So,
The quoting is okay, I tested again
> If you have doubts about what you actually granted, do this:
> SHOW GRANTS FOR 'user'
I've sent this command:
grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass';
Then tested the show grants
On Sun, May 20, 2007 17:34, Vitaliy Okulov wrote:
> Здравствуйте, Mogens.
>
>> --disable-keys, -K
>>
>> On Sun, May 20, 2007 16:28, Vitaliy Okulov wrote:
>>> Здравствуйте, mysql.
>>>
>>> How i can speedup restore of mysql DB from file created by mysqldump?
>>>
>
> Ok, but for innodb?
>
Well, you
Mathieu Bruneau wrote:
Baron Schwartz a écrit :
Hi,
Miguel Cardenas wrote:
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES
Vitaliy Okulov wrote:
> > How i can speedup restore of mysql DB from file created by mysqldump?
[snip]
Ok, but for innodb?
1) Disable foreign key checks: SET FOREIGN_KEY_CHECKS=0 (remember to re-enable
afterwards). Disable unique checks too: SET UNIQUE_CHECKS=0
2) Insert the rows in primar
Здравствуйте, Mogens.
Вы писали 20 мая 2007 г., 18:47:33:
> --disable-keys, -K
> For each table, surround the INSERT statements with /*!4 ALTER TABLE
> tbl_name DISABLE KEYS */; and /*!4 ALTER TABLE tbl_name ENABLE KEYS
> */; statements. This makes loading the dump file faster because th
Baron Schwartz a écrit :
> Hi,
>
> Miguel Cardenas wrote:
>> Hello list
>>
>> I have a problem adding a user with host '%' ...
>>
>> *** If I add a user with host '%' when trying to connect get this error:
>> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
>> password: YES)
--disable-keys, -K
For each table, surround the INSERT statements with /*!4 ALTER TABLE
tbl_name DISABLE KEYS */; and /*!4 ALTER TABLE tbl_name ENABLE KEYS
*/; statements. This makes loading the dump file faster because the
indexes are created after all rows are inserted. This option is ef
Здравствуйте, mysql.
How i can speedup restore of mysql DB from file created by mysqldump?
--
С уважением,
Vitaliy mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
12 matches
Mail list logo
