Import SQL baze
2 naročnika
2 naročnika
Pozdravljeni,
na tem linku sem si potegnil testno bazo, katero želim uvoziti na računalniku v MySQL server (v 5.5.13).
Uvoz delam preko MySQL Administratorja (v 1.2.17), kjer sem ustvaril novo bazo in želel narediti restore, s katerim bi importal preneseno bazo. Obkljukal sem tudi Ignore Errors.
V bazi se kreirajo tabele, vendar pa se podatki v njih ne zapišejo. Spodaj je en del loga, ki se mi izpiše ob importu. Izgleda, kot da SQL ne zna delati s temi .dump fajli, v katerih so dejanski podatki.
Kdo ve, kako bi to rešil? Hvala!
Warning: Do not know how to handle this statement at line 28:
SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 43:
select CONCAT('storage engine: ', @@storage_engine) as INFO;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 106:
SELECT 'LOADING departments' as 'INFO';
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 107:
source load_departments.dump ;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 108:
SELECT 'LOADING employees' as 'INFO';
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 109:
source load_employees.dump ;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
...
2 odgovora
Uhhh za mysql nevem ampak tudi tam mislim da se zadeve ne začnejo s select ampak kar s craete database in create table as.... in to AS info tud nevem čemu služi za vse zadeve... si prepričan da imaš mysql bazo?
Vrsta datoteke: Microsoft SQL Server Query File (.sql) (torej bi moglo bit ok...)
Sem probal takole:
C:\Users\jst\Desktop\Baza podatkov\Ekstrahirano\employees_db>"C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysql.exe" -u root -p employees < employees.sql
Pa mi javlja error Dostop je zavrnjen. :(