Help - Search - Members - Calendar
Full Version: How To Use A Sql File With Zymic's Mysqo Databases
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
MoonLight_Dream
hello, I got a tutorial off the net, it has a LOT of php files and such, no problem.
The problem lies with the fact it needs to connect to a mysql db for accessing and writing/editing tables in it.
In the tut, there is a .SQL, how do I get it into the database? when i tried an upload inside the phpmyadmin, using the import, it gave me an error.

QUOTE
Error

SQL query:

CREATE DATABASE IF NOT EXISTS plaincart;

MySQL said: Documentation
#1044 - Access denied for user 'starlightwish_user'@'localhost' to database 'plaincart'


my db name is starlightwish_plaincart
my db username is starlightwish_user
the file i am uploading is plaincart.sql

if you want i will quote the sql file code too.
Mortalis9
db name is too long i think, youll have to make a new one
MoonLight_Dream
i tried making one with just db as the name, didnt work.
so I'll try a different approach, how do I copy paste from the file into the db?

in the sql, it has code to create tables and users, etc, how can i do the same with the phpmyadmin controls?
anhduc
I don't Know SQL Name . Help Me!!!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2012 Invision Power Services, Inc.