dissipate
Sep 11 2004, 09:57 AM
| | Is there any way to convert a mySQL dump (.sql file) to an access file? Problem is, I downloaded and installed the mySQL server and ran it. But I couldn't restore the dump - it kept complaining about charsets and even the guy who created the dump didn't know what was up.
So I'm looking for another way to access the contents of the database. Help anyone? |
Comment/Reply (w/o sign-up)
daf
Sep 11 2004, 10:20 AM
The guy who created dump file can create a .csv or .xls file and send it to you. Then you only need to import it in your mysql db. cheers
Comment/Reply (w/o sign-up)
kilz
Sep 14 2004, 11:56 AM
or you can use phpmyadmin to do that. it's must be easier.
Comment/Reply (w/o sign-up)
dissipate
Sep 16 2004, 02:45 PM
eh? what's phpmyadmin? never heard of it.
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : sql, access
- Database Access On Remote Server W/jsp
(2)
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
Accessing Ms Access Database From A Centralized Location?
(10) Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t....
Integrate Access Database Onto Intranet Site
Looking to integrate access database into my intranet site (5) Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the same d....
Access 97 To Access 2003
(15) I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the
Convert tools of Access 2003 i got some errors and can't change or add any of the objects
-tables, querys, etc- of the converted database. All the errors i got are related to the user
priviligies and permissions of the database, is there exists a way or procedure that allows me to
reset this permissions??? Best regards,....
Access
Is this easy to make a login/password? (17) I was looking to make a site where people need to create an account, and log in to view the main
pages. Is it easy, or do-able, to use msoft access to make a database where people are able to sign
up with a username and password via my website?....
Public Access Oracle Db?
(5) This may be the stupidest question ever, I don't know, but frankly if this exists it would help
me out a lot haha. What I'm looking for is an oracle database set up somewhere that has an open
uname/password for the public to use for testing or anything really. I'm just developing
something that needs to connect to our oracle db here but we don't want the computers to be
required to have the oracle client installed. Currently though all the computers I have access to
here DO have it installed and need it to stay for the time being, and I can't access o....
Can't Import Backup Sql File To Localhost
(11) Hi, I downloaded a backup of my forum database and wanted to import it on my computer locally for
testing purposes. This has always worked for me in the past, but I'm having some problems with
it lately. I'm backing up my database via phpMyAdmin->Database->Export->Select All and
downloaded as a .gz file. I'm using Windows XP Home with WAMP installed, so it has MySQL built
in. It's version 5.0.27. I ran all the services and at the prompt typed in: mysql -u root -p
backup.sql > testDB My root account in WAMP has no password, so when it prompts for a ....
MS Access Validation Rule
Desperate help needed (4) I have to create a whole project using Microfost Access. I have a field which will eventaually
contain details of a a list of people's DOBs. I have added an input mask, so that it it displays
the place holder __/__/____ However, how can I validate this field. For example, not it is possible
to type 30/10/1991 . How can this be changed so that it validates it correctly?....
Access -> Mysql
Converter (8) I have a problem. Is any program wchich converts database Access to Mysql ??....
Read/Write Issues After Copying An Access .mdb File
(4) Alright, I'm currently creating an interface program for a MS Access database. I've only
used Access once in the past but used other DB's a handful of times so I didn't have any
trouble getting the general program created. My issue arose when I tried to make it so that the
users needing to use the program can just copy the .exe and the .mdb files and use it. The program
doesn't require users to share the database but to store their OWN programs information in their
OWN database, so basically each needs to have their own database with the exact same d....
MS Access DB To Webpage Connection ?
(6) ok .. i have this little problem i am going through ... Leme explain this project of mine first . I
have a MS Access DB of student fields like ID no, Name, Marks .. etc .. This one Access DB would be
updated by just adding more rows and would be done on the server. It looks sumthing like this:
Now .. I have a HTML page that shows this : I would enter the ID number of a student (no
authentication .. anyone can access anybodys marks), and when i hit submit .. I would be taken to a
page that gets the values from the ID specified and shows it in the next page. The pa....
Help With Registration Page, Access Denied.
(10) I'm coming up with an error that I can't figure out in my registration page. Below I've
given the error message and the code. QUOTE Warning: mysql_connect(): Access denied for user:
'nobody@localhost' (Using password: NO) in /home/lonebyrd/public_html/db_connect.php on line
33 Access denied for user: 'nobody@localhost' (Using password: NO) CODE $Host =
"localhost"; // define host name (default: localhost) $User = "$lonebyrd_razmo"; // define database
username $Password = "$****"; // define database password $Database = "$lonebyrd....
How To Restore A Sql.gz File
(5) How do i restore a sql.gz file? Im confused /mellow.gif" style="vertical-align:middle"
emoid=":mellow:" border="0" alt="mellow.gif" />....
Help Me With My MS-Access Program
(2) Hi anyone can help me with making a form. These are the case; I am using Ms. Access XP, and a
database for using as a admission database for new students. And using couple table for the base,
however I want that when the operator is trying to add a students (add button), a form will came up,
and asking for his/her ID and password and Cliking the LOGIN button and lookup for the ID and
Password which stored in a "user" table on the database. When the ID and Password 're correct
the function for adding students can be processed, but when the ID and Password uncorrect....
I Have A Question About MySQL Access & Quotas
(1) On my previous web host, I surpassed my MySQL quota limit. At least, that's what they told me.
The following message is the error I get. phpBB : Critical Error Error creating new session
DEBUG MODE SQL Error : 1044 Access denied for user: 'darnem_trials@65.98.98.74' to database
'darnem_trials' INSERT INTO phpbb_sessions (session_id, session_user_id, session_start,
session_time, session_ip, session_page, session_logged_in) VALUES
('7719681862d0a4bfc392929af1357326', 2, 1125023783, 1125023783, '18d160ac', 0, 1)
Line : 168 File : ....
Recover Tables From A MySQL .frm File
(9) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
Sample My.cnf - MySQL Configuration File
if you need as startup (2) Hi all, Recently there has been lots of questions about configuring MySQL. Usually the rpm
comes with a few sample MySQL config files, but here I'm providing you with a fully working one
for your reference. Feel free to modify it to suit your needs. One word: My MySQL is configured to
use only large InnoDB Databases, because of the large volume of transactions it handles. You'll
find a reflection of that in the my.cnf... Most home users would use ISAM DB instead. So make the
suitable modifications before you use... Sample "my.cnf" QUOTE #-----------....
Logic To Break Down An Access Tabbe To SQL
what is the easiest way to split this? (1) I have 3 differen tables in this database that are basically repeating the same data. How can I
split it up and still use it. This is the horse project /smile.gif" style="vertical-align:middle"
emoid=":)" border="0" alt="smile.gif" /> the 3 tables are called Horse, Dam, Sire . the Horse table
should be enough for all the data. (at least that is what I'm thinking) the Dam & Sire are
used to track lineage and are setup Like this: CODE SireID; Horse; Sire; Dam; SireSire;
SireDam; DamSire: DamDam; SireSireSire; SireSireDam; SireDamSire; SireDamDam; DamSireSire;D....
Access
Lesons (0) The HP Learning center offers very good free lessons on creating databases with step by step
instructions. You can access the learing center at HP Learing Center ....
Access To MySQL Remotely
(2) i am using a software to access to mysql remotely but it display error!(Access denied for
myusername@my ip address) please help me....
Is php supports MS Access
Ms Access Database (7) I want to know that is php supports MS Access databases. And could anyone told me the complete php
installation. I have little bit problem during installation.....
How To Transition The Database
transition the database to access (2) i want to transition the records in SQL7 to ACCESS in the condition of VF 6.0 how i can?....
How To Access a Remote MySQL
(1) I try to access to a remote mysql owned by my friend , I have the IP and username and password. but
I always got this information: Fatal error: Maximum execution time of 30 seconds exceeded in
XXXXXXXXXXXXXXXX....
Looking for sql, access
|
See Also,
*SIMILAR VIDEOS*
Searching Video's for sql, access
|
advertisement
|
|
