Re: [chiPHPug-discuss] Import/restore .sql file?

[Ryan G. <sok...@gm...>]

The < filename.sql syntax only works at the unix command prompt, not
the mysql command prompt. To import a file from there do
mysql> use database_name
mysql> source filename.sql

On Thu, Nov 20, 2008 at 10:47 PM, Janine Starykowicz
<jr...@ba...> wrote:
> I'm in Windows.  I've tried doing all kinds of variations on what you
> posted, and keep getting a syntax error.
>
> Janine
>
> Anacreo wrote:
>> You want to make sure you're not in the "mysql>" prompt when you're doing
>> this...
>>
>> Try something like:
>>
>> unix prompt> mysql -u **** -p ****** -h localhost database < filename.sql
>>
>> If you're in Windows the syntax would be a bit different.
>>
>> Alec
>>
>> On Thu, Nov 20, 2008 at 11:56 PM, Janine Starykowicz <jr...@ba...
>>
>>> wrote:
>>>
>>
>>
>>> I am attempting to mirror SMF on my WinXP laptop to test upgrades.  I
>>> have Apache, PHP, mySQL, and one working install of Drupal all tested
>>> and running.  Apache, PHP and mySQL are all installed in c:\Program
>>> Files.  Database is created and empty and I exported the .sql file
>>> through phpMyAdmin from my public server.
>>>
>>> After logging in to mysql and using the database, at the command line
>>> mysql> I enter:
>>> mysql -u **** -p ****** -h localhost database < filename.sql;
>>> where user and password is for mySQL
>>>
>>> and get:
>>> ERROR 1064 (42000): You have an error in your SQL syntax; check the
>>> manual that
>>> corresponds to your MySQL server version for the right syntax to use
>>> near 'mysql
>>> -u **** -p ******* -h localhost database < filename.sql' at line 1
>>>
>>> I have also tried exiting mysql and changing (with cd) to the MySQL
>>> subdirectory (where the .sql file is).  That gives me a long list of
>>> commands instead of an error message, but the database is still empty
>>> and I am not running mysql when the commands finish listing.
>>>
>>> I have tried taking out the spaces after -u and -p.  I've tried leaving
>>> the space after -u, no space after -p and no space after < with ./ as
>>> the path.
>>>
>>> I tried installing MySQL Tools and using the MySQL Administrator, it
>>> said it can't restore files generated by mysqldump.
>>>
>>> What am I doing wrong?  Where should I put the .sql file and how should
>>> I list the path?  Which spaces are needed?
>>>
>>> Thanks!
>>> Janine
>>>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> chiPHPug-discuss mailing list
> chi...@li...
> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss
>