PHP5/ MySQL extension PROBLEM

[edizarca]

Hello buds ,

Yesterday i installed Apache server , PHP5 , and MySQL onto my laptop for testing my web page purposes.

ALL looks like working properly but i need to restore the .sql file into mysql.
It was unsuccessful.
I backed up my database on the host to my laptop.
The problem was , mysql admin doesnt restore sqldump files.

If this can be solved, my problem is solved , i tried it failed. then i decided to install phpmyadmin.

I copied the files , but it keeps on saying.

phpMyAdmin - Error

Cannot load mysql extension. Please check your PHP configuration. - Documentation

-----

mysql extension is included in my php.ini file.

extension=php_mysql.dll

just like that.

----------

still no help there

any help from you guys would be appreciated.

[VGR]

phpmyadmin is useless

if you did a mysqldump() of your database, given the versions are not too different, importaing your data back in the new server is a piece of cake. It's better done, simply, by issuing at the DOS command prompt (where mysql/bin is accessible in the path) :
mysql --user=you --password=youtoo < dumpfile.sql

the error you got : "could not load mysql extension" smells very bad. It looks like you didn't folow the real install procedure. You ***should*** find startup errors of mysql in the machinename.err file which lies in the mysql/data directory (or the one specified in my.ini/my.cnf as "datadir")

best regards

[edizarca]

Thanks for reply ,

As you have noticed I am a total newbie on this.
But I followed every step on the tutorial , and did the control acts to check them , they all look workig fine , just the extension thingy.

Theres no mysql section on my phpinfo file.

-----

in the err file this is what i get.

-----

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
071223  6:35:25  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
071223  6:35:26  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 24 MB
InnoDB: Database physically writes the file full: wait...
071223  6:35:27  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 24 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
071223  6:35:29  InnoDB: Started; log sequence number 0 0
071223  6:35:30 [Note] D:\WEB\SERVER\MySQL\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)
071223  6:49:02 [Note] D:\WEB\SERVER\MySQL\bin\mysqld-nt: Normal shutdown

071223  6:49:02  InnoDB: Starting shutdown...
071223  6:49:05  InnoDB: Shutdown completed; log sequence number 0 43655
071223  6:49:05 [Note] D:\WEB\SERVER\MySQL\bin\mysqld-nt: Shutdown complete

071223  6:49:07  InnoDB: Started; log sequence number 0 43655
071223  6:49:07 [Note] D:\WEB\SERVER\MySQL\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)
071223  7:00:52 [Note] D:\WEB\SERVER\MySQL\bin\mysqld-nt: Normal shutdown

071223  7:00:52  InnoDB: Starting shutdown...
071223  7:00:53  InnoDB: Shutdown completed; log sequence number 0 43655
071223  7:00:53 [Note] D:\WEB\SERVER\MySQL\bin\mysqld-nt: Shutdown complete

071223  7:00:54  InnoDB: Started; log sequence number 0 43655
071223  7:00:54 [Note] D:\WEB\SERVER\MySQL\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)

[VGR]

the .err file seems ok ; the mysqld server seems ready for connections
the phpinfo() absence of a mysql section is abnormal IMHO ; the mysql client can't be started
there's something wrong in the middle.

probably the lib4ts not in the path or the like.Now check the Apache's error file.


have you tried launching the "mysql" console client ("DOS" window/"command-line", mysql) ?