phpMyAdmin and MySQL

[max]

I have a web host with PHP my Admin and mySQL.
Can anybody give me an instruction how to make a sample database and access it?

[Jon Kraft]

max <mliokum@yahoo.com> wrote:

> I have a web host with PHP my Admin and mySQL.
> Can anybody give me an instruction how to make a sample database and
> access it?

[url]http://www.google.com/search?q=php+mysql+tutorial[/url]

JOn
--
I think my career is ruined!

[Joaquim Amado Lopes]

Greetings.

I'm using PHP and MySQL to create websites and phpMyAdmin to manage
and transfer the databases, from my PC to the remote servers and back.

After dumping the database from one server to an SQL file, I run that
file in the other server (on phpMyAdmin) to replicate the database.
But, when I do that, phpMyAdmin only executes the first SQL
instruction, ignoring the rest of the SQL file.
I've tried different dump setups but the result is always the same.

I'm using:
MySQL 3.23.47-nt and phpMyAdmin 2.2.6 on the PC
MySQL 3.23.54 and phpMyAdmin 2.2.6 on the remote server

Can anyone help me on this?

Thank you for your time,
Joaquim Amado Lopes

[Tim Van Wassenhove]

On 2003-12-22, Joaquim Amado Lopes <remove-jal.usenet.2003@jalopes.net> wrote:

> After dumping the database from one server to an SQL file, I run that
> file in the other server (on phpMyAdmin) to replicate the database.
> But, when I do that, phpMyAdmin only executes the first SQL
> instruction, ignoring the rest of the SQL file.
> I've tried different dump setups but the result is always the same.

Just add a line on top of the dumpfile (fill in the right databasename):
use databasename;


--
verum ipsum factum

[Joaquim Amado Lopes]

Greetings.

On 22 Dec 2003 00:52:01 GMT, Tim Van Wassenhove <euki@pi.be> wrote:

>On 2003-12-22, Joaquim Amado Lopes <remove-jal.usenet.2003@jalopes.net> wrote:

>> After dumping the database from one server to an SQL file, I run that
>> file in the other server (on phpMyAdmin) to replicate the database.
>> But, when I do that, phpMyAdmin only executes the first SQL
>> instruction, ignoring the rest of the SQL file.
>> I've tried different dump setups but the result is always the same.

>
>Just add a line on top of the dumpfile (fill in the right databasename):
>use databasename;
>

Now it says "No SQL query!".
I opened the file with a text editor and the instructions are all
there.

Take care,
Joaquim

[Eagle]

Hi There:

I am using the same software combination and never actually
experienced this kind of problem. I would recommend you update your
phpMyAdmin to the current version 2.5.4 Later versions always fix a
couple of bugs pf previous versions which may possibly cause such
error. Download from [url]http://www.phpmyadmin.net/[/url]



On Mon, 22 Dec 2003 00:47:44 +0000, Joaquim Amado Lopes
<remove-jal.usenet.2003@jalopes.net> wrote:

>Greetings.
>
>I'm using PHP and MySQL to create websites and phpMyAdmin to manage
>and transfer the databases, from my PC to the remote servers and back.
>
>After dumping the database from one server to an SQL file, I run that
>file in the other server (on phpMyAdmin) to replicate the database.
>But, when I do that, phpMyAdmin only executes the first SQL
>instruction, ignoring the rest of the SQL file.
>I've tried different dump setups but the result is always the same.
>
>I'm using:
>MySQL 3.23.47-nt and phpMyAdmin 2.2.6 on the PC
>MySQL 3.23.54 and phpMyAdmin 2.2.6 on the remote server
>
>Can anyone help me on this?
>
>Thank you for your time,
>Joaquim Amado Lopes

Eagle

(I very much appreciate your contributions.
Please do not reply to my email-address since it is deactivated due to tons of Spam I received.
Thanks a ton)