PDA

View Full Version : how can I creat table in mySql ???


sunpetch
4-5-03, 12:23 AM
Hi all!!

I am new in here...Do you know how can I import the SQl file from my computer into the mysql databse in this powweb server ??

Phpmyadmin ?? I have copy the phpmyadin into /htdoc/ directories, and there is an error happen..i don;t have a permission to access ???

So i download the mascon program from powweb 's advise..but i don;t know how to use it..

Any one can help me ??

thank you very much:D

Grymwulf
4-5-03, 02:24 PM
Try using MySQLCC from the MySQL mainsite, you can access it - then access the database, open an SQL query, copy the SQL file's text into the query box and it will do it all -

Here's the link:

http://www.mysql.com/downloads/mysqlcc.html

netaustin
4-5-03, 03:57 PM
I'd use MySQL Front to import .SQL files into the database... just one thing to remember, though - break the long INSERT commands into several shorter commands, because powweb servers have a tendency to freak out when you try to insert TOO much from a remote location.

PhpMyAdmin: make sure you edit the config.inc.php file correctly, allowing it to auto-detect the directory in which it resides.

sunpetch
4-5-03, 04:19 PM
Hi,

Thank you for your advise..:): I already made it..:
Now I can import the SQL file into the database..

But i am still have another problem..haha
the script doesnot run like when i test on my computer..T_T..

I am thinking about the configuration of the script.
I am using the OSCOMMERCE script, i think you guy know this one already...but for me ?? Just learning on them..:)

If you know about Oscommerce, can you help on that ?? Because i try to set the server name and ssl server name, I am thinking that i set it correctly, but there is some thing mistake on the document path. Becuase the pattern of the oscommerce doesn;t show up and everything is messed up..:(

Do you know where is should put the index.php or default.php in to which directories ?? htdocs/ ???

But the problem is when i run the script in my computer, the fold CATALOG (there is default.php and lot of php script in it ) in the localhost directoies. the standard configuration is set to localhost and user database is root and no passward. I can run that complete perfect...

So i upload everything into htdocs/catalog/ , and the script doesnot work correctly...:(

Do you know what should i do ??
Finally, I have to apologize for my bad english...I am not familiar with english as much as our language..
Thank you very much

sunpetch
4-5-03, 04:22 PM
oh by the way, I don;t know if i have to copy php.ini into all directories or not..
I have ask about php.ini ,because i am still confusing about what powweb said in the tutorial about php.ini. They said, I have to copy php.ini into all directories,becuae it work directories by directories..

Is this the reason ???